DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on PER_COLLECTIVE_AGREEMENTS

Line 1525: ,per_collective_agreements pca

1521: ,decode(pca.cag_information6, 'Y', '1', 'N', '2') temp_to_contr
1522: ,decode(pca.cag_information7, 'Y', '1', 'N', '2') termination
1523: ,decode(pca.cag_information8, 'Y', '1', 'N', '2') appr_temp_worker
1524: FROM per_all_assignments_f pas
1525: ,per_collective_agreements pca
1526: WHERE pas.assignment_id = p_assignment_id
1527: AND p_start_date BETWEEN pas.effective_start_date
1528: AND pas.effective_end_date
1529: AND pca.collective_agreement_id = pas.collective_agreement_id