APPS.RCV_RECEIPTS_QUERY_SV dependencies on PJM_PROJECTS_ALL_V

Line 396: from pjm_projects_all_v pa,

392: Begin
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;

Line 415: from pjm_projects_all_v

411: Begin
412:
413: select project_number
414: into x_project_number
415: from pjm_projects_all_v
416: where project_id = X_project_id;
417:
418: Exception
419: when no_data_found then

Line 513: pjm_projects_all_v PPA, --

509: po_lookup_codes polc,
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

Line 1017: l_dummy2 PJM_PROJECTS_ALL_V.project_number%TYPE;

1013: x_oe_order_line_id IN NUMBER,
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