DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PER_CONTRACTS_F

Line 579: FROM PER_CONTRACTS_f pcf

575: ,c_assignment_id NUMBER
576: ,c_effective_date DATE) IS
577: SELECT sum(CTR_INFORMATION2) In_Class_trng_hours
578: ,sum(CTR_INFORMATION3) Remote_trng_hours
579: FROM PER_CONTRACTS_f pcf
580: ,per_all_assignments_f paaf
581: WHERE paaf.assignment_id = c_assignment_id
582: AND paaf.business_group_id = c_business_gr_id
583: AND paaf.contract_id = pcf.contract_id