DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PAY_COST_ALLOCATIONS_F

Line 1745: pay_cost_allocations_f pcaf,

1741:
1742: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1743: SELECT pcak.cost_allocation_keyflex_id
1744: FROM per_all_assignments_f assg,
1745: pay_cost_allocations_f pcaf,
1746: pay_cost_allocation_keyflex pcak
1747: WHERE assg.assignment_id = pcaf.assignment_id
1748: AND assg.assignment_id = l_assignment_id
1749: AND assg.Primary_flag = 'Y'

Line 1894: pay_cost_allocations_f pcaf,

1890:
1891: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1892: SELECT pcak.cost_allocation_keyflex_id
1893: FROM per_all_assignments_f assg,
1894: pay_cost_allocations_f pcaf,
1895: pay_cost_allocation_keyflex pcak
1896: WHERE assg.assignment_id = pcaf.assignment_id
1897: AND assg.assignment_id = l_assignment_id
1898: AND assg.Primary_flag = 'Y'