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_COLLECTIVE_AGREEMENTS

Line 9654: FROM per_collective_agreements pca

9650: AND pps.period_of_service_id = paaf.period_of_service_id;*/
9651: --
9652: CURSOR csr_get_cao_code(c_collective_agreement_id NUMBER) IS
9653: SELECT pca.cag_information1
9654: FROM per_collective_agreements pca
9655: WHERE pca.collective_agreement_id = c_collective_agreement_id
9656: AND pca.cag_information_category= 'NL';
9657: --
9658: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS

Line 10068: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;

10064: p_date DATE;
10065: l_retro VARCHAR2(10);
10066: l_type VARCHAR2(10);
10067: l_ovn pay_action_information.object_version_number%type;
10068: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
10069: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
10070: l_bal_value Bal_Value;
10071: l_nom_bal_value Bal_Value;
10072: l_ret_table Ret_Table;

Line 10069: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;

10065: l_retro VARCHAR2(10);
10066: l_type VARCHAR2(10);
10067: l_ovn pay_action_information.object_version_number%type;
10068: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
10069: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
10070: l_bal_value Bal_Value;
10071: l_nom_bal_value Bal_Value;
10072: l_ret_table Ret_Table;
10073: l_assignment_action_id NUMBER;

Line 14008: FROM per_collective_agreements pca

14004: AND pap.effective_end_date;
14005: --
14006: CURSOR csr_get_cao_code(c_collective_agreement_id NUMBER) IS
14007: SELECT pca.cag_information1
14008: FROM per_collective_agreements pca
14009: WHERE pca.collective_agreement_id = c_collective_agreement_id
14010: AND pca.cag_information_category= 'NL';
14011: --
14012: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER

Line 14258: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;

14254: p_date DATE;
14255: l_retro VARCHAR2(10);
14256: l_type VARCHAR2(10);
14257: l_ovn pay_action_information.object_version_number%type;
14258: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
14259: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
14260: l_bal_value Bal_Value;
14261: l_nom_bal_value Bal_Value;
14262: l_ret_table Ret_Table;

Line 14259: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;

14255: l_retro VARCHAR2(10);
14256: l_type VARCHAR2(10);
14257: l_ovn pay_action_information.object_version_number%type;
14258: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
14259: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
14260: l_bal_value Bal_Value;
14261: l_nom_bal_value Bal_Value;
14262: l_ret_table Ret_Table;
14263: l_assignment_action_id NUMBER;