DBA Data[Home] [Help]

APPS.HR_RO_CONTRACT_VAL dependencies on PER_CONTRACTS_F

Line 159: from per_contracts_f

155: IS
156:
157: cursor csr_contract_exists is
158: select 'x'
159: from per_contracts_f
160: where person_id = p_person_id
161: and p_effective_date between effective_start_date and effective_end_date;
162:
163: l_exists varchar2(1);