APPS.RCV_RECEIPTS_QUERY_SV dependencies on PJM_PROJECTS_ALL_V

Line 417: from pjm_projects_all_v pa,

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

Line 436: from pjm_projects_all_v

432: Begin
433:
434: select project_number
435: into x_project_number
436: from pjm_projects_all_v
437: where project_id = X_project_id;
438:
439: Exception
440: when no_data_found then

Line 534: pjm_projects_all_v PPA, --

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

Line 1019: l_dummy2 PJM_PROJECTS_ALL_V.project_number%TYPE;

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