DBA Data[Home] [Help]

APPS.PAY_EMP_ACTION_ARCH dependencies on PER_CONTRACTS

Line 1630: from per_contracts

1626:
1627: cursor c_get_contract(cp_contract_id in number
1628: ,cp_effective_date in date) is
1629: select reference
1630: from per_contracts
1631: where contract_id = cp_contract_id
1632: and p_effective_date between effective_start_date
1633: and effective_end_date;
1634: lv_contract VARCHAR2(240);