APPS.GMS_AWARDS_DIST_PKG dependencies on GMS_PROJECT_TYPES

Line 895: gms_project_types gpt

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
899: AND pp.project_type = gpt.project_type

Line 995: gms_project_types gpt

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
999: and rd2.award_id is NOT NULL

Line 1147: gms_project_types gpt

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
1151: AND gpt.sponsored_flag = 'Y'

Line 1204: gms_project_types gpt

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
1208: AND gpt.sponsored_flag = 'N' ) ;