DBA Data[Home] [Help]

APPS.OTA_BULK_ENROLL_UTIL dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 1549: pay_cost_allocation_keyflex pcak

1545: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1546: SELECT pcak.cost_allocation_keyflex_id
1547: FROM per_all_assignments_f assg,
1548: pay_cost_allocations_f pcaf,
1549: pay_cost_allocation_keyflex pcak
1550: WHERE assg.assignment_id = pcaf.assignment_id
1551: AND assg.assignment_id = l_assignment_id
1552: AND assg.Primary_flag = 'Y'
1553: AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id

Line 1679: pay_cost_allocation_keyflex pcak

1675: CURSOR csr_get_cost_center_info(l_assignment_id NUMBER) IS
1676: SELECT pcak.cost_allocation_keyflex_id
1677: FROM per_all_assignments_f assg,
1678: pay_cost_allocations_f pcaf,
1679: pay_cost_allocation_keyflex pcak
1680: WHERE assg.assignment_id = pcaf.assignment_id
1681: AND assg.assignment_id = l_assignment_id
1682: AND assg.Primary_flag = 'Y'
1683: AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id