DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_COLLECTIVE_AGREEMENTS

Line 1665: from per_collective_agreements

1661:
1662: cursor c_get_collective_agreement(cp_collective_agreement_id in number
1663: ,cp_effective_date in date) is
1664: select name
1665: from per_collective_agreements
1666: where collective_agreement_id = cp_collective_agreement_id
1667: and start_date <= cp_effective_date
1668: and nvl(end_date, cp_effective_date) >= cp_effective_date;
1669: