APPS.OTA_DELEGATE_BOOKING_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 154: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

150: l_activity_version_id ota_activity_versions.activity_version_id%type;
151: l_offering_id ota_events.offering_id%type;
152: l_user number;
153: l_cost_allocation_keyflex_id VARCHAR2(1000);
154: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
155: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
156:
157: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
158: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 155: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

151: l_offering_id ota_events.offering_id%type;
152: l_user number;
153: l_cost_allocation_keyflex_id VARCHAR2(1000);
154: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
155: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
156:
157: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
158: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;
159: fapi_result VARCHAR2(40);

Line 183: FROM per_all_assignments_f paf

179: AND evt.organization_id = hao.organization_id (+);
180:
181: CURSOR csr_get_assignment_info IS
182: SELECT paf.organization_id
183: FROM per_all_assignments_f paf
184: WHERE paf.assignment_id = p_delegate_assignment_id;
185:
186: CURSOR csr_get_cost_center_info IS
187: SELECT pcak.cost_allocation_keyflex_id

Line 188: FROM per_all_assignments_f assg,

184: WHERE paf.assignment_id = p_delegate_assignment_id;
185:
186: CURSOR csr_get_cost_center_info IS
187: SELECT pcak.cost_allocation_keyflex_id
188: FROM per_all_assignments_f assg,
189: pay_cost_allocations_f pcaf,
190: pay_cost_allocation_keyflex pcak
191: WHERE assg.assignment_id = pcaf.assignment_id
192: AND assg.assignment_id = p_delegate_assignment_id