APPS.PAY_NL_WAGE_REPORT_PKG dependencies on PER_COLLECTIVE_AGREEMENTS

Line 5986: FROM per_collective_agreements pca

5982: AND pps.period_of_service_id = paaf.period_of_service_id;*/
5983: --
5984: CURSOR csr_get_cao_code(c_collective_agreement_id NUMBER) IS
5985: SELECT pca.cag_information1
5986: FROM per_collective_agreements pca
5987: WHERE pca.collective_agreement_id = c_collective_agreement_id
5988: AND pca.cag_information_category= 'NL';
5989: --
5990: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS

Line 6324: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;

6320: p_date DATE;
6321: l_retro VARCHAR2(10);
6322: l_type VARCHAR2(10);
6323: l_ovn pay_action_information.object_version_number%type;
6324: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6325: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6326: l_bal_value Bal_Value;
6327: l_nom_bal_value Bal_Value;
6328: l_ret_table Ret_Table;

Line 6325: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;

6321: l_retro VARCHAR2(10);
6322: l_type VARCHAR2(10);
6323: l_ovn pay_action_information.object_version_number%type;
6324: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6325: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
6326: l_bal_value Bal_Value;
6327: l_nom_bal_value Bal_Value;
6328: l_ret_table Ret_Table;
6329: l_assignment_action_id NUMBER;

Line 8419: FROM per_collective_agreements pca

8415: AND pap.effective_end_date;
8416: --
8417: CURSOR csr_get_cao_code(c_collective_agreement_id NUMBER) IS
8418: SELECT pca.cag_information1
8419: FROM per_collective_agreements pca
8420: WHERE pca.collective_agreement_id = c_collective_agreement_id
8421: AND pca.cag_information_category= 'NL';
8422: --
8423: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER

Line 8604: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;

8600: p_date DATE;
8601: l_retro VARCHAR2(10);
8602: l_type VARCHAR2(10);
8603: l_ovn pay_action_information.object_version_number%type;
8604: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8605: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8606: l_bal_value Bal_Value;
8607: l_nom_bal_value Bal_Value;
8608: l_ret_table Ret_Table;

Line 8605: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;

8601: l_retro VARCHAR2(10);
8602: l_type VARCHAR2(10);
8603: l_ovn pay_action_information.object_version_number%type;
8604: l_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8605: l_old_cao_code per_collective_agreements.CAG_INFORMATION1%type;
8606: l_bal_value Bal_Value;
8607: l_nom_bal_value Bal_Value;
8608: l_ret_table Ret_Table;
8609: l_assignment_action_id NUMBER;