APPS.PA_FUNDS_CONTROL_PKG1 dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 2804: FROM ap_self_assessed_tax_dist_all apd ,

2800: SELECT apd.invoice_distribution_id,
2801: DECODE(apd.line_type_lookup_code
2802: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code),'PREPAY')
2803: ,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code))
2804: FROM ap_self_assessed_tax_dist_all apd ,
2805: psa_bc_xla_events_gt xlaevt,
2806: ap_invoices_all apinv
2807: WHERE apd.bc_event_id = xlaevt.event_id
2808: AND apd.project_id IS NOT NULL

Line 3067: FROM AP_SELF_ASSESSED_TAX_DIST_ALL AID,

3063: ,NVL(AID.amount,0) - NVL(AID.amount_variance,0)
3064: - NVL(AID.quantity_variance,0) encumbrance_amount
3065: ,AID.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
3066: ,AID.self_assessed_flag self_assessed_tax_flag
3067: FROM AP_SELF_ASSESSED_TAX_DIST_ALL AID,
3068: PO_DISTRIBUTIONS_ALL POD,
3069: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3070: IGC_CC_SLA_BFLOW_PRIOR_V IGC,
3071: ap_system_parameters_all ASP

Line 3095: FROM ap_self_assessed_tax_dist_all apd2

3091: AND p_bc_mode <> 'C'
3092: AND apd1.line_type_lookup_code = 'PREPAY')
3093: AND NOT EXISTS ( /*Bug 13602288 :Self Assessed Tax Changes*/
3094: SELECT 1
3095: FROM ap_self_assessed_tax_dist_all apd2
3096: WHERE apd2.invoice_distribution_id = apext.charge_applicable_to_dist_id
3097: AND apext.aid_line_type_lookup_code = 'NONREC_TAX'
3098: AND apext.charge_applicable_to_dist_id IS NOT NULL
3099: AND p_bc_mode <> 'C'

Line 3225: AP_SELF_ASSESSED_TAX_DIST_ALL AID

3221: AID.parent_reversal_id parent_reversal_id
3222: FROM AP_PREPAY_HISTORY_ALL APPH,
3223: AP_PREPAY_APP_DISTS APAD,
3224: AP_INVOICE_LINES_ALL AIL,
3225: AP_SELF_ASSESSED_TAX_DIST_ALL AID
3226: WHERE AID.bc_event_id = APPH.bc_Event_id
3227: AND APPH.prepay_history_id = APAD.prepay_history_id
3228: AND AID.invoice_line_number = AIL.line_number
3229: AND AID.invoice_id = AIL.invoice_id

Line 3254: FROM ap_self_assessed_tax_dist_all apd,

3250: SELECT apd.set_of_books_id,
3251: apd.expenditure_item_date,
3252: apd.org_id,
3253: apinv.vendor_id
3254: FROM ap_self_assessed_tax_dist_all apd,
3255: ap_invoices_all apinv
3256: WHERE apd.invoice_distribution_id = p_inv_dist_id
3257: AND apinv.invoice_id = apd.invoice_id;
3258: