APPS.GMS_AWARDS_DIST_PKG dependencies on PA_PROJECTS_ALL

Line 874: pa_projects_all pp,

870: rd.created_by created_by,
871: nvl(rd.last_update_login,0) last_update_login
872: FROM po_req_distributions_all rd,
873: po_requisition_lines_all rl,
874: pa_projects_all pp,
875: gms_project_types gpt
876: WHERE rl.requisition_header_id = p_header_id
877: AND rd.requisition_line_id = rl.requisition_line_id
878: AND rd.project_id = pp.project_id

Line 974: pa_projects_all pp,

970: SELECT rd2.distribution_id
971: bulk collect into l_dummy_tab
972: FROM po_req_distributions_all rd2,
973: po_requisition_lines_all rl,
974: pa_projects_all pp,
975: gms_project_types gpt
976: WHERE rl.requisition_header_id = p_header_id
977: AND rd2.requisition_line_id = rl.requisition_line_id
978: AND rd2.project_id = pp.project_id

Line 1126: pa_projects_all p,

1122: pod.last_updated_by last_updated_by,
1123: pod.created_by created_by,
1124: nvl(pod.last_update_login,0) last_update_login
1125: FROM po_distributions_all pod,
1126: pa_projects_all p,
1127: gms_project_types gpt
1128: WHERE pod.po_header_id = p_header_id
1129: AND pod.project_id = p.project_id
1130: AND p.project_type = gpt.project_type

Line 1183: pa_projects_all p,

1179: WHERE pod.po_header_id = p_header_id
1180: AND pod.award_id is not NULL
1181: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id
1182: FROM po_distributions_all pod2,
1183: pa_projects_all p,
1184: gms_project_types gpt
1185: WHERE pod2.po_header_id = p_header_id
1186: AND pod2.project_id = p.project_id
1187: AND p.project_type = gpt.project_type