APPS.RCV_RECEIPTS_QUERY_SV dependencies on PA_TASKS_EXPEND_V

Line 397: pa_tasks_expend_v pt

393:
394: select pa.project_number,pt.task_number
395: into x_project_number,x_task_number
396: from pjm_projects_all_v pa,
397: pa_tasks_expend_v pt
398: where pa.project_id = X_project_id
399: and pt.task_id = X_task_id
400: and pa.project_id=pt.project_id;
401:

Line 514: pa_tasks_expend_v PTE --

510: po_requisition_lines PRL, --
511: po_req_distributions PRD, --
512: mtl_kanban_cards MKC, --
513: pjm_projects_all_v PPA, --
514: pa_tasks_expend_v PTE --
515: WHERE polc.lookup_type = 'RCV DESTINATION TYPE'
516: AND polc.lookup_code = NVL( rsl.destination_type_code, 'INVENTORY')
517: AND rsl.shipment_line_id = x_shipment_line_id
518: AND hlo.location_id(+) = rsl.deliver_to_location_id

Line 1018: l_dummy3 PA_TASKS_EXPEND_V.task_number%TYPE;

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