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.

APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_SHARED_TYPES

Line 6166: FROM per_shared_types

6162: CURSOR csr_get_shared_types(c_code VARCHAR2
6163: ,c_business_gr_id NUMBER
6164: ,c_lookup VARCHAR2) IS
6165: SELECT business_group_id,system_type_cd
6166: FROM per_shared_types
6167: WHERE lookup_type = c_lookup --'NL_NATIONALITY'
6168: AND information1 = c_code
6169: AND (business_group_id = c_business_gr_id
6170: OR business_group_id is NULL)

Line 6279: l_nationality per_shared_types.INFORMATION1%type;

6275: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
6276: AND ast.per_system_status = 'TERM_ASSIGN';
6277: --
6278: --soft_coding_keyflex_id
6279: l_nationality per_shared_types.INFORMATION1%type;
6280: l_assignment_catg per_shared_types.INFORMATION1%type;
6281: l_assignment_catg_old per_shared_types.INFORMATION1%type;
6282: l_emp_rec csr_get_emp_data%rowtype;
6283: l_rec_changes Rec_Changes;

Line 6280: l_assignment_catg per_shared_types.INFORMATION1%type;

6276: AND ast.per_system_status = 'TERM_ASSIGN';
6277: --
6278: --soft_coding_keyflex_id
6279: l_nationality per_shared_types.INFORMATION1%type;
6280: l_assignment_catg per_shared_types.INFORMATION1%type;
6281: l_assignment_catg_old per_shared_types.INFORMATION1%type;
6282: l_emp_rec csr_get_emp_data%rowtype;
6283: l_rec_changes Rec_Changes;
6284: l_rec_changes_init Rec_Changes;

Line 6281: l_assignment_catg_old per_shared_types.INFORMATION1%type;

6277: --
6278: --soft_coding_keyflex_id
6279: l_nationality per_shared_types.INFORMATION1%type;
6280: l_assignment_catg per_shared_types.INFORMATION1%type;
6281: l_assignment_catg_old per_shared_types.INFORMATION1%type;
6282: l_emp_rec csr_get_emp_data%rowtype;
6283: l_rec_changes Rec_Changes;
6284: l_rec_changes_init Rec_Changes;
6285: l_master_action_info_id pay_action_information.action_information_id%type;

Line 8458: FROM per_shared_types

8454: CURSOR csr_get_shared_types(c_code VARCHAR2
8455: ,c_business_gr_id NUMBER
8456: ,c_lookup VARCHAR2) IS
8457: SELECT business_group_id,system_type_cd
8458: FROM per_shared_types
8459: WHERE lookup_type = c_lookup --'NL_NATIONALITY'
8460: AND information1 = c_code
8461: AND (business_group_id = c_business_gr_id
8462: OR business_group_id is NULL)

Line 8566: l_nationality per_shared_types.INFORMATION1%type;

8562: AND paaf.assignment_status_type_id = ast.assignment_status_type_id
8563: AND ast.per_system_status = 'TERM_ASSIGN';
8564: --
8565: --soft_coding_keyflex_id
8566: l_nationality per_shared_types.INFORMATION1%type;
8567: l_assignment_catg per_shared_types.INFORMATION1%type;
8568: l_assignment_catg_old per_shared_types.INFORMATION1%type;
8569: l_emp_rec csr_get_emp_data%rowtype;
8570: l_rec_changes Rec_Changes;

Line 8567: l_assignment_catg per_shared_types.INFORMATION1%type;

8563: AND ast.per_system_status = 'TERM_ASSIGN';
8564: --
8565: --soft_coding_keyflex_id
8566: l_nationality per_shared_types.INFORMATION1%type;
8567: l_assignment_catg per_shared_types.INFORMATION1%type;
8568: l_assignment_catg_old per_shared_types.INFORMATION1%type;
8569: l_emp_rec csr_get_emp_data%rowtype;
8570: l_rec_changes Rec_Changes;
8571: l_rec_changes_init Rec_Changes;

Line 8568: l_assignment_catg_old per_shared_types.INFORMATION1%type;

8564: --
8565: --soft_coding_keyflex_id
8566: l_nationality per_shared_types.INFORMATION1%type;
8567: l_assignment_catg per_shared_types.INFORMATION1%type;
8568: l_assignment_catg_old per_shared_types.INFORMATION1%type;
8569: l_emp_rec csr_get_emp_data%rowtype;
8570: l_rec_changes Rec_Changes;
8571: l_rec_changes_init Rec_Changes;
8572: l_master_action_info_id pay_action_information.action_information_id%type;