APPS.GMS_COST_PLUS_EXTN dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1241: -- ap_invoice_distributions_all apd

1237: select adl.ind_compiled_set_id
1238: into l_compiled_set_id
1239: from gms_award_distributions adl
1240: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1241: -- ap_invoice_distributions_all apd
1242: where adl.award_id = x_award_id
1243: and adl.task_id = x_task_id
1244: and adl.invoice_id = x_document_header_id
1245: and adl.invoice_distribution_id = x_document_distribution_id -- AP Lines change

Line 2629: from ap_invoice_distributions_all apd1,

2625: apd2.expenditure_organization_id,
2626: adl.resource_list_member_id,
2627: adl.bud_task_id,
2628: adl.ind_compiled_set_id
2629: from ap_invoice_distributions_all apd1,
2630: ap_invoice_distributions_all apd2,
2631: gms_award_distributions adl
2632: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2633: and apd2.invoice_distribution_id = apd1.prepay_distribution_id

Line 2630: ap_invoice_distributions_all apd2,

2626: adl.resource_list_member_id,
2627: adl.bud_task_id,
2628: adl.ind_compiled_set_id
2629: from ap_invoice_distributions_all apd1,
2630: ap_invoice_distributions_all apd2,
2631: gms_award_distributions adl
2632: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2633: and apd2.invoice_distribution_id = apd1.prepay_distribution_id
2634: and apd2.award_id = adl.award_set_id

Line 2647: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;

2643: l_sum_count NUMBER ;
2644: l_header_id NUMBER ;
2645: l_memo NUMBER ;
2646:
2647: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;
2648: l_prepay_dist_id NUMBER ;
2649: l_prepayment_brc number ;
2650: l_prepay_header_id NUMBER ;
2651: l_prepay_award_set_id NUMBER ;

Line 4220: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is

4216: BEGIN
4217: null; -- All code remove as this will be taken care by Interface FC
4218: END PPAY_LOG_POSTING ;
4219:
4220: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is
4221: BEGIN
4222: null; -- All code remove as this will be taken care by Interface FC
4223: END CALC_prepayment_burden ;
4224:

Line 4399: ap_invoice_distributions_all apd

4395: --
4396: select adl.ind_compiled_set_id
4397: into x_ind_compiled_set_id
4398: from gms_award_distributions adl,
4399: ap_invoice_distributions_all apd
4400: where apd.distribution_line_number = x_distribution_line_number
4401: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4402: and apd.award_id = adl.award_set_id
4403: and adl.adl_line_num = 1 ;

Line 4468: ap_invoice_distributions_all apd

4464: --
4465: select adl.burdenable_raw_cost
4466: into x_burdenable_raw_cost
4467: from gms_award_distributions adl,
4468: ap_invoice_distributions_all apd
4469: where apd.distribution_line_number = x_distribution_line_number
4470: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4471: and apd.award_id = adl.award_set_id
4472: and adl.adl_line_num = 1 ;