DBA Data[Home] [Help]

APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_CONTRACTS_F

Line 1896: FROM PER_CONTRACTS_f pcf

1892: IS
1893: CURSOR csr_get_contract_end_date(c_assignment_id NUMBER
1894: ,c_effective_date DATE) IS
1895: SELECT NVL(fnd_date.canonical_to_date(CTR_INFORMATION4),to_date('31-12-4712','dd-mm-yyyy')) Contract_End_Date
1896: FROM PER_CONTRACTS_f pcf
1897: ,per_all_assignments_f paaf
1898: WHERE paaf.assignment_id = c_assignment_id
1899: AND paaf.contract_id = pcf.contract_id
1900: AND pcf.ctr_information_category = 'ES'