This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbes

This page was created on 26-Nov-2021 10:22 by rforbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
4 26-Nov-2021 10:22 1 KB rforbes to previous
3 26-Nov-2021 10:22 908 bytes rforbes to previous | to last
2 26-Nov-2021 10:22 867 bytes rforbes to previous | to last
1 26-Nov-2021 10:22 884 bytes rforbes to last

Page References

Incoming links Outgoing links
P 2 K_PU.ELEMENT_PC
P2K_PU.ELEMENT_PC

Version management

Difference between version and

At line 1 changed one line
!!Element Information
!!Element Information
At line 3 changed 2 lines
!Functionality:
This function retrieves a comma seperated list of pay components as seen on IPEL.
!Functionality:
This function retrieves a comma seperated list of pay components (enclosed within single quotes) as seen on IPEL.
!Parameters:
At line 6 changed 5 lines
!Parameters:
|ELEMENT_CODE | The element code you are examining
|BASIC_ONLY | ''optional'' If any value other than "N" is specified here, then only the basic pay copmonents on that element are provided. Otherwise (default) the basic and compound elements are included.
|ELEMENT_CODE | The element code you are examining
|BASIC_ONLY | ''optional'' If any value other than "N" is specified here, then only the basic pay copmonents on that element are provided. Otherwise (default) the basic and compound elements are included.
At line 12 changed one line
Varchar2
Varchar2 or NULL if there are no pay components defined in that element
At line 14 changed 2 lines
!Errors:
* {{*BAD ELEMENT }} When there is no element defined with that code name* {{*BAD WHAT }} When the WHAT parameter is not one of the values supported
!Errors:
* {{*BAD ELEMENT }} When there is no element defined with that code name
At line 20 changed 3 lines
;:Will return a comma seperated list of pay component codes (e.g. "6802, 6852, 6911")
----
![Notes|Edit:Internal.P2K_PU.ELEMENT_PC]
;:Will return a comma seperated list of pay component codes (e.g. '6802','6852','6911')
This can be used in reporting with a where clause that looks as such:
{{{instr(p2k_pu.element_pc(''element_code''),'''40''')>0}}}
----
![Notes|Edit:Internal.P2K_PU.ELEMENT_PC]
At line 30 added one line
This page (revision-4) was last changed on 26-Nov-2021 10:22 by rforbesTop