APPS.OTA_DELEGATE_BOOKING_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;

161: l_activity_version_id ota_activity_versions.activity_version_id%type;
162: l_offering_id ota_events.offering_id%type;
163: l_user number;
164: l_cost_allocation_keyflex_id VARCHAR2(1000);
165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
167: l_booking_status_type varchar2(10);
168:
169: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;

Line 166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;

162: l_offering_id ota_events.offering_id%type;
163: l_user number;
164: l_cost_allocation_keyflex_id VARCHAR2(1000);
165: l_business_group_id_from PER_ALL_ASSIGNMENTS_F.business_group_id%TYPE;
166: l_organization_id PER_ALL_ASSIGNMENTS_F.organization_id%TYPE;
167: l_booking_status_type varchar2(10);
168:
169: fapi_finance_header_id OTA_FINANCE_LINES.finance_header_id%TYPE;
170: fapi_object_version_number OTA_FINANCE_LINES.object_version_number%TYPE;

Line 195: FROM per_all_assignments_f paf

191: AND evt.organization_id = hao.organization_id (+);
192:
193: CURSOR csr_get_assignment_info IS
194: SELECT paf.organization_id
195: FROM per_all_assignments_f paf
196: WHERE paf.assignment_id = p_delegate_assignment_id;
197:
198: CURSOR csr_get_cost_center_info IS
199: SELECT pcak.cost_allocation_keyflex_id

Line 200: FROM per_all_assignments_f assg,

196: WHERE paf.assignment_id = p_delegate_assignment_id;
197:
198: CURSOR csr_get_cost_center_info IS
199: SELECT pcak.cost_allocation_keyflex_id
200: FROM per_all_assignments_f assg,
201: pay_cost_allocations_f pcaf,
202: pay_cost_allocation_keyflex pcak
203: WHERE assg.assignment_id = pcaf.assignment_id
204: AND assg.assignment_id = p_delegate_assignment_id