APPS.GMS_COST_PLUS_EXTN dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1508: -- ap_invoice_distributions_all apd

1504: select adl.ind_compiled_set_id
1505: into l_compiled_set_id
1506: from gms_award_distributions adl
1507: -- R12 Funds Managment Uptake : Obsolete Ap/PO/REQ usage as its not required
1508: -- ap_invoice_distributions_all apd
1509: where adl.award_id = x_award_id
1510: and adl.task_id = x_task_id
1511: and adl.invoice_id = x_document_header_id
1512: and adl.invoice_distribution_id = x_document_distribution_id -- AP Lines change

Line 2929: from ap_invoice_distributions_all apd1,

2925: apd2.expenditure_organization_id,
2926: adl.resource_list_member_id,
2927: adl.bud_task_id,
2928: adl.ind_compiled_set_id
2929: from ap_invoice_distributions_all apd1,
2930: ap_invoice_distributions_all apd2,
2931: gms_award_distributions adl
2932: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2933: and apd2.invoice_distribution_id = apd1.prepay_distribution_id

Line 2930: ap_invoice_distributions_all apd2,

2926: adl.resource_list_member_id,
2927: adl.bud_task_id,
2928: adl.ind_compiled_set_id
2929: from ap_invoice_distributions_all apd1,
2930: ap_invoice_distributions_all apd2,
2931: gms_award_distributions adl
2932: where apd1.invoice_distribution_id = bc_pkt_rec.document_distribution_id
2933: and apd2.invoice_distribution_id = apd1.prepay_distribution_id
2934: and apd2.award_id = adl.award_set_id

Line 2973: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;

2969: l_sum_count NUMBER ;
2970: l_header_id NUMBER ;
2971: l_memo NUMBER ;
2972:
2973: l_prepay_type ap_invoice_distributions_all.line_type_lookup_code%TYPE ;
2974: l_prepay_dist_id NUMBER ;
2975: l_prepayment_brc number ;
2976: l_prepay_header_id NUMBER ;
2977: l_prepay_award_set_id NUMBER ;

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

4598: BEGIN
4599: null; -- All code remove as this will be taken care by Interface FC
4600: END PPAY_LOG_POSTING ;
4601:
4602: PROCEDURE CALC_prepayment_burden( X_AP_REC ap_invoice_distributions_all%ROWTYPE , X_adl_rec gms_award_distributions%ROWTYPE ) is
4603: BEGIN
4604: null; -- All code remove as this will be taken care by Interface FC
4605: END CALC_prepayment_burden ;
4606:

Line 4790: ap_invoice_distributions_all apd

4786: /* BUG 14216205 : Commented the below code : Starts */
4787: /*select adl.ind_compiled_set_id
4788: into x_ind_compiled_set_id
4789: from gms_award_distributions adl,
4790: ap_invoice_distributions_all apd
4791: where apd.distribution_line_number = x_distribution_line_number
4792: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4793: and apd.award_id = adl.award_set_id
4794: and adl.adl_line_num = 1 ;*/

Line 4802: ap_invoice_distributions_all apd

4798: BEGIN
4799: select adl.ind_compiled_set_id
4800: into x_ind_compiled_set_id
4801: from gms_award_distributions adl,
4802: ap_invoice_distributions_all apd
4803: where apd.distribution_line_number = x_distribution_line_number
4804: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4805: and apd.award_id = adl.award_set_id
4806: and ADL.ADL_LINE_NUM = 1 ;

Line 4890: ap_invoice_distributions_all apd

4886: /* BUG 14216205 : Commented the below code : Starts */
4887: /*select adl.burdenable_raw_cost
4888: into x_burdenable_raw_cost
4889: from gms_award_distributions adl,
4890: ap_invoice_distributions_all apd
4891: where apd.distribution_line_number = x_distribution_line_number
4892: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4893: and apd.award_id = adl.award_set_id
4894: and adl.adl_line_num = 1 ;*/

Line 4902: ap_invoice_distributions_all apd

4898: BEGIN
4899: select adl.burdenable_raw_cost
4900: into x_burdenable_raw_cost
4901: from gms_award_distributions adl,
4902: ap_invoice_distributions_all apd
4903: where apd.distribution_line_number = x_distribution_line_number
4904: and apd.invoice_distribution_id = x_distribution_id -- AP Lines change
4905: and apd.award_id = adl.award_set_id
4906: and adl.adl_line_num = 1 ;