APPS.GMS_AWARDS_DIST_PKG dependencies on PA_PROJECTS_ALL

Line 894: pa_projects_all pp,

890: rd.created_by created_by,
891: nvl(rd.last_update_login,0) last_update_login
892: FROM po_req_distributions_all rd,
893: po_requisition_lines_all rl,
894: pa_projects_all pp,
895: gms_project_types gpt
896: WHERE rl.requisition_header_id = p_header_id
897: AND rd.requisition_line_id = rl.requisition_line_id
898: AND rd.project_id = pp.project_id

Line 994: pa_projects_all pp,

990: SELECT rd2.distribution_id
991: bulk collect into l_dummy_tab
992: FROM po_req_distributions_all rd2,
993: po_requisition_lines_all rl,
994: pa_projects_all pp,
995: gms_project_types gpt
996: WHERE rl.requisition_header_id = p_header_id
997: AND rd2.requisition_line_id = rl.requisition_line_id
998: AND rd2.project_id = pp.project_id

Line 1146: pa_projects_all p,

1142: pod.last_updated_by last_updated_by,
1143: pod.created_by created_by,
1144: nvl(pod.last_update_login,0) last_update_login
1145: FROM po_distributions_all pod,
1146: pa_projects_all p,
1147: gms_project_types gpt
1148: WHERE pod.po_header_id = p_header_id
1149: AND pod.project_id = p.project_id
1150: AND p.project_type = gpt.project_type

Line 1203: pa_projects_all p,

1199: WHERE pod.po_header_id = p_header_id
1200: AND pod.award_id is not NULL
1201: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id
1202: FROM po_distributions_all pod2,
1203: pa_projects_all p,
1204: gms_project_types gpt
1205: WHERE pod2.po_header_id = p_header_id
1206: AND pod2.project_id = p.project_id
1207: AND p.project_type = gpt.project_type