eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_SHARED_TYPES

Line 9835: FROM per_shared_types

9831: CURSOR csr_get_shared_types(c_code VARCHAR2
9832: ,c_business_gr_id NUMBER
9833: ,c_lookup VARCHAR2) IS
9834: SELECT business_group_id,system_type_cd
9835: FROM per_shared_types
9836: WHERE lookup_type = c_lookup --'NL_NATIONALITY'
9837: AND information1 = c_code
9838: AND (business_group_id = c_business_gr_id
9839: OR business_group_id is NULL)

Line 10016: l_nationality per_shared_types.INFORMATION1%type;

10012: AND ppf.effective_end_date;
10013: -- /*LC 2010 */ end
10014: --
10015: --soft_coding_keyflex_id
10016: l_nationality per_shared_types.INFORMATION1%type;
10017: l_assignment_catg per_shared_types.INFORMATION1%type;
10018: l_assignment_catg_old per_shared_types.INFORMATION1%type;
10019: l_emp_rec csr_get_emp_data%rowtype;
10020: l_rec_changes Rec_Changes;

Line 10017: l_assignment_catg per_shared_types.INFORMATION1%type;

10013: -- /*LC 2010 */ end
10014: --
10015: --soft_coding_keyflex_id
10016: l_nationality per_shared_types.INFORMATION1%type;
10017: l_assignment_catg per_shared_types.INFORMATION1%type;
10018: l_assignment_catg_old per_shared_types.INFORMATION1%type;
10019: l_emp_rec csr_get_emp_data%rowtype;
10020: l_rec_changes Rec_Changes;
10021: l_rec_changes_init Rec_Changes;

Line 10018: l_assignment_catg_old per_shared_types.INFORMATION1%type;

10014: --
10015: --soft_coding_keyflex_id
10016: l_nationality per_shared_types.INFORMATION1%type;
10017: l_assignment_catg per_shared_types.INFORMATION1%type;
10018: l_assignment_catg_old per_shared_types.INFORMATION1%type;
10019: l_emp_rec csr_get_emp_data%rowtype;
10020: l_rec_changes Rec_Changes;
10021: l_rec_changes_init Rec_Changes;
10022: l_master_action_info_id pay_action_information.action_information_id%type;

Line 14048: FROM per_shared_types

14044: CURSOR csr_get_shared_types(c_code VARCHAR2
14045: ,c_business_gr_id NUMBER
14046: ,c_lookup VARCHAR2) IS
14047: SELECT business_group_id,system_type_cd
14048: FROM per_shared_types
14049: WHERE lookup_type = c_lookup --'NL_NATIONALITY'
14050: AND information1 = c_code
14051: AND (business_group_id = c_business_gr_id
14052: OR business_group_id is NULL)

Line 14213: l_nationality per_shared_types.INFORMATION1%type;

14209: and aei_information_category = 'NL_NUMIV_OVERRIDE';
14210: l_numiv_override NUMBER;
14211:
14212: --soft_coding_keyflex_id
14213: l_nationality per_shared_types.INFORMATION1%type;
14214: l_assignment_catg per_shared_types.INFORMATION1%type;
14215: l_assignment_catg_old per_shared_types.INFORMATION1%type;
14216: l_emp_rec csr_get_emp_data%rowtype;
14217: l_rec_changes Rec_Changes;

Line 14214: l_assignment_catg per_shared_types.INFORMATION1%type;

14210: l_numiv_override NUMBER;
14211:
14212: --soft_coding_keyflex_id
14213: l_nationality per_shared_types.INFORMATION1%type;
14214: l_assignment_catg per_shared_types.INFORMATION1%type;
14215: l_assignment_catg_old per_shared_types.INFORMATION1%type;
14216: l_emp_rec csr_get_emp_data%rowtype;
14217: l_rec_changes Rec_Changes;
14218: l_rec_changes_init Rec_Changes;

Line 14215: l_assignment_catg_old per_shared_types.INFORMATION1%type;

14211:
14212: --soft_coding_keyflex_id
14213: l_nationality per_shared_types.INFORMATION1%type;
14214: l_assignment_catg per_shared_types.INFORMATION1%type;
14215: l_assignment_catg_old per_shared_types.INFORMATION1%type;
14216: l_emp_rec csr_get_emp_data%rowtype;
14217: l_rec_changes Rec_Changes;
14218: l_rec_changes_init Rec_Changes;
14219: l_master_action_info_id pay_action_information.action_information_id%type;