DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_CONTRACTS

Line 1700: from per_contracts

1696:
1697: cursor c_get_contract(cp_contract_id in number
1698: ,cp_effective_date in date) is
1699: select reference
1700: from per_contracts
1701: where contract_id = cp_contract_id
1702: and p_effective_date between effective_start_date
1703: and effective_end_date;
1704: lv_contract VARCHAR2(240);