APPS.RCV_RECEIPTS_QUERY_SV dependencies on PA_TASKS_EXPEND_V

Line 418: pa_tasks_expend_v pt

414:
415: select pa.project_number,pt.task_number
416: into x_project_number,x_task_number
417: from pjm_projects_all_v pa,
418: pa_tasks_expend_v pt
419: where pa.project_id = X_project_id
420: and pt.task_id = X_task_id
421: and pa.project_id=pt.project_id;
422:

Line 535: pa_tasks_expend_v PTE --

531: po_requisition_lines PRL, --
532: po_req_distributions PRD, --
533: mtl_kanban_cards MKC, --
534: pjm_projects_all_v PPA, --
535: pa_tasks_expend_v PTE --
536: WHERE polc.lookup_type = 'RCV DESTINATION TYPE'
537: AND polc.lookup_code = NVL( rsl.destination_type_code, 'INVENTORY')
538: AND rsl.shipment_line_id = x_shipment_line_id
539: AND hlo.location_id(+) = rsl.deliver_to_location_id

Line 1020: l_dummy3 PA_TASKS_EXPEND_V.task_number%TYPE;

1016: x_from_org_id IN NUMBER DEFAULT NULL) IS
1017: /* create dummy variables just to store throw-away values */
1018: l_dummy1 MTL_KANBAN_CARDS.kanban_card_number%TYPE;
1019: l_dummy2 PJM_PROJECTS_ALL_V.project_number%TYPE;
1020: l_dummy3 PA_TASKS_EXPEND_V.task_number%TYPE;
1021: l_dummy4 GL_CODE_COMBINATIONS_KFV.concatenated_segments%TYPE;
1022:
1023: BEGIN
1024: RCV_RECEIPTS_QUERY_SV.post_query(