APPS.GMS_COST_PLUS_EXTN dependencies on AP_SELF_ASSESSED_TAX_DIST

Line 517: AP_SELF_ASSESSED_TAX_DIST apsat,

513: , adl.resource_list_member_id
514: , adl.bud_task_id
515: , adl.ind_compiled_set_id
516: from AP_INVOICES I,
517: AP_SELF_ASSESSED_TAX_DIST apsat,
518: gms_award_distributions ADL,
519: GL_LEDGERS G
520: where i.invoice_id = apsat.invoice_id
521: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

Line 705: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,

701: , adl.resource_list_member_id
702: , adl.bud_task_id
703: , adl.ind_compiled_set_id
704: from AP_INVOICES I,
705: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
706: gms_award_distributions ADL,
707: gl_ledgers g
708: where i.invoice_id = apsat.invoice_id
709: and pa_cmt_utils.get_apdist_amt(apsat.invoice_distribution_id,

Line 2796: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,

2792: apsat.expenditure_organization_id,
2793: adl.resource_list_member_id,
2794: adl.bud_task_id,
2795: ADL.IND_COMPILED_SET_ID
2796: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,
2797: gms_award_distributions ADL,
2798: GL_LEDGERS G
2799: where adl.invoice_distribution_id = APSAT.invoice_distribution_id
2800: and adl.adl_status = 'A'

Line 2954: from AP_SELF_ASSESSED_TAX_DIST_ALL apsat1,

2950: apsat2.expenditure_organization_id,
2951: adl.resource_list_member_id,
2952: adl.bud_task_id,
2953: ADL.IND_COMPILED_SET_ID
2954: from AP_SELF_ASSESSED_TAX_DIST_ALL apsat1,
2955: AP_SELF_ASSESSED_TAX_DIST_ALL apsat2,
2956: GMS_AWARD_DISTRIBUTIONS ADL
2957: where APSAT1.INVOICE_DISTRIBUTION_ID = BC_PKT_REC.DOCUMENT_DISTRIBUTION_ID
2958: and apsat2.invoice_distribution_id = apsat1.prepay_distribution_id

Line 2955: AP_SELF_ASSESSED_TAX_DIST_ALL apsat2,

2951: adl.resource_list_member_id,
2952: adl.bud_task_id,
2953: ADL.IND_COMPILED_SET_ID
2954: from AP_SELF_ASSESSED_TAX_DIST_ALL apsat1,
2955: AP_SELF_ASSESSED_TAX_DIST_ALL apsat2,
2956: GMS_AWARD_DISTRIBUTIONS ADL
2957: where APSAT1.INVOICE_DISTRIBUTION_ID = BC_PKT_REC.DOCUMENT_DISTRIBUTION_ID
2958: and apsat2.invoice_distribution_id = apsat1.prepay_distribution_id
2959: and apsat2.award_id = adl.award_set_id

Line 3002: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,

2998: and ap.invoice_id = P_RECORD.document_header_id
2999: and ap.invoice_distribution_id = P_RECORD.document_distribution_id -- AP Lines change
3000: union /* BUG 14216205 : Added the union for SAT */
3001: select ADL.AWARD_SET_ID , ADL.ADL_LINE_NUM
3002: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,
3003: GMS_AWARD_DISTRIBUTIONS ADL
3004: where adl.invoice_distribution_id = APSAT.invoice_distribution_id
3005: and adl.adl_status = 'A'
3006: and ADL.AWARD_ID = P_RECORD.AWARD_ID

Line 3047: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,

3043: 'N',
3044: 'GMS',nvl(g.sla_ledger_cash_basis_flag,'N') ) ) sum_amount ,
3045: sum(nvl(adl.burdenable_raw_cost,0)) sum_burden,
3046: COUNT(*) SUM_COUNT
3047: FROM AP_SELF_ASSESSED_TAX_DIST APSAT,
3048: gms_award_distributions ADL,
3049: gl_ledgers G
3050: where adl.invoice_distribution_id = APSAT.invoice_distribution_id
3051: and adl.adl_status = 'A'

Line 4815: AP_SELF_ASSESSED_TAX_DIST_ALL apsat

4811: when NO_DATA_FOUND then
4812: select adl.ind_compiled_set_id
4813: into x_ind_compiled_set_id
4814: from GMS_AWARD_DISTRIBUTIONS ADL,
4815: AP_SELF_ASSESSED_TAX_DIST_ALL apsat
4816: where apsat.distribution_line_number = x_distribution_line_number
4817: and apsat.invoice_distribution_id = x_distribution_id -- AP Lines change
4818: and apsat.AWARD_ID = ADL.AWARD_SET_ID
4819: and ADL.ADL_LINE_NUM = 1 ;

Line 4915: AP_SELF_ASSESSED_TAX_DIST_ALL apsat

4911: when no_data_found then
4912: select adl.burdenable_raw_cost
4913: into x_burdenable_raw_cost
4914: from GMS_AWARD_DISTRIBUTIONS ADL,
4915: AP_SELF_ASSESSED_TAX_DIST_ALL apsat
4916: where apsat.distribution_line_number = x_distribution_line_number
4917: and apsat.invoice_distribution_id = x_distribution_id -- AP Lines change
4918: and apsat.AWARD_ID = ADL.AWARD_SET_ID
4919: and ADL.ADL_LINE_NUM = 1 ;