DBA Data[Home] [Help]

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: