DBA Data[Home] [Help]

APPS.GMS_COST_PLUS_EXTN dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

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 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 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 ;