APPS.PAY_EMP_ACTION_ARCH dependencies on PER_COLLECTIVE_AGREEMENTS
Line 1595: from per_collective_agreements
1591:
1592: cursor c_get_collective_agreement(cp_collective_agreement_id in number
1593: ,cp_effective_date in date) is
1594: select name 1595: from per_collective_agreements 1596: where collective_agreement_id = cp_collective_agreement_id
1597: and start_date <= cp_effective_date
1598: and nvl(end_date, cp_effective_date) >= cp_effective_date;
1599: