DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 1746: pay_cost_allocation_keyflex pcak

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'
1750: AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id

Line 1895: pay_cost_allocation_keyflex pcak

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'
1899: AND pcaf.cost_allocation_keyflex_id = pcak.cost_allocation_keyflex_id