DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1465: --po_req_distributions_all por

1461: select adl.ind_compiled_set_id
1462: into l_compiled_set_id
1463: from gms_award_distributions adl
1464: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1465: --po_req_distributions_all por
1466: where adl.award_id = x_award_id
1467: and adl.task_id = x_task_id
1468: and adl.distribution_id = x_document_distribution_id
1469: and adl.document_type = 'REQ'

Line 2361: po_req_distributions_all req

2357: SELECT adl.burdenable_raw_cost burden_amount,
2358: adl.adl_line_num,
2359: adl.award_set_id
2360: FROM gms_award_distributions adl ,
2361: po_req_distributions_all req
2362: WHERE adl.distribution_id = p_record.document_distribution_id
2363: AND req.distribution_id = p_record.document_distribution_id
2364: AND req.award_id = adl.award_set_id
2365: and adl.adl_status = 'A'

Line 4763: po_req_distributions_all req

4759: --
4760: select adl.ind_compiled_set_id
4761: into x_ind_compiled_set_id
4762: from gms_award_distributions adl,
4763: po_req_distributions_all req
4764: where req.distribution_id = x_distribution_id
4765: and req.award_id = adl.award_set_id
4766: and adl.adl_line_num = 1 ;
4767:

Line 4863: po_req_distributions_all req

4859: --
4860: select adl.burdenable_raw_cost
4861: into x_burdenable_raw_cost
4862: from gms_award_distributions adl,
4863: po_req_distributions_all req
4864: where req.distribution_id = x_distribution_id
4865: and req.award_id = adl.award_set_id
4866: and adl.adl_line_num = 1 ;
4867: