APPS.GMS_FUNDS_CONTROL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 461: from AP_SELF_ASSESSED_TAX_DIST_ALL C,

457: and COALESCE(b.charge_applicable_to_dist_id,b.related_id,b.invoice_distribution_id) =
458: COALESCE(a.charge_applicable_to_dist_id,a.related_id,a.invoice_distribution_id)
459: union /* BUG 14216205 : Added the union for SAT */
460: select distinct D.INVOICE_ID,D.INVOICE_DISTRIBUTION_ID
461: from AP_SELF_ASSESSED_TAX_DIST_ALL C,
462: AP_SELF_ASSESSED_TAX_DIST_ALL D
463: where (c.invoice_id,c.invoice_distribution_id) in
464: (select document_header_id,
465: document_distribution_id

Line 462: AP_SELF_ASSESSED_TAX_DIST_ALL D

458: COALESCE(a.charge_applicable_to_dist_id,a.related_id,a.invoice_distribution_id)
459: union /* BUG 14216205 : Added the union for SAT */
460: select distinct D.INVOICE_ID,D.INVOICE_DISTRIBUTION_ID
461: from AP_SELF_ASSESSED_TAX_DIST_ALL C,
462: AP_SELF_ASSESSED_TAX_DIST_ALL D
463: where (c.invoice_id,c.invoice_distribution_id) in
464: (select document_header_id,
465: document_distribution_id
466: from gms_bc_packets gbc

Line 1339: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,

1335: SELECT DISTINCT adl.award_set_id,
1336: adl.document_type,
1337: adl.invoice_id,
1338: adl.invoice_distribution_id
1339: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
1340: GMS_AWARD_DISTRIBUTIONS ADL
1341: WHERE APSAT.INVOICE_DISTRIBUTION_ID = P_INV_DIST_ID
1342: AND APSAT.AWARD_ID IS NOT NULL
1343: AND APSAT.AWARD_ID = ADL.AWARD_SET_ID

Line 1543: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT

1539: and adl2.adl_status = 'I'
1540: union /* BUG 14216205 : Added the union for SAT */
1541: select ADL3.AWARD_SET_ID
1542: from GMS_AWARD_DISTRIBUTIONS ADL3,
1543: AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
1544: where APSAT.INVOICE_ID = g_doc_header_id_tab(i)
1545: AND apsat.invoice_distribution_id = g_doc_dist_id_tab(i)
1546: AND apsat.award_id IS NOT NULL
1547: and ADL3.AWARD_SET_ID = APSAT.AWARD_ID

Line 1659: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL

1655: SET award_id = x_rec.award_set_id
1656: WHERE invoice_id = g_doc_header_id_tab(i)
1657: AND invoice_distribution_id = g_doc_dist_id_tab(i);
1658: /* BUG 14216205 : Added the following Code for SAT : Starts */
1659: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL
1660: SET award_id = x_rec.award_set_id
1661: where INVOICE_ID = G_DOC_HEADER_ID_TAB(I)
1662: AND invoice_distribution_id = g_doc_dist_id_tab(i);
1663: /* BUG 14216205 : Added the following Code for SAT : Ends */

Line 2328: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,

2324: UNION /* BUG 14216205 : Added the union for SAT */
2325: SELECT apsat.invoice_distribution_id,
2326: DECODE (apsat.prepay_distribution_id ,NULL,line_type_lookup_code,'PREPAY')
2327: from PSA_BC_XLA_EVENTS_GT XLAEVT,
2328: AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2329: gms_project_types gpt,
2330: pa_projects_all pp,
2331: ap_invoices_all apinv
2332: WHERE apsat.bc_event_id = xlaevt.event_id

Line 2556: FROM AP_SELF_ASSESSED_TAX_DIST_ALL ASAT,

2552: - NVL(ASAT.base_quantity_variance,NVL(ASAT.quantity_variance,0)) encumbrance_base_amount
2553: ,NVL(ASAT.amount,0) - NVL(ASAT.amount_variance,0)
2554: - NVL(ASAT.quantity_variance,0) encumbrance_amount
2555: ,ASAT.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
2556: FROM AP_SELF_ASSESSED_TAX_DIST_ALL ASAT,
2557: PO_DISTRIBUTIONS_ALL POD,
2558: IGC_CC_SLA_BFLOW_PRIOR_V IGC
2559: WHERE nvl(ASAT.posted_flag,'N') <> 'Y'
2560: AND ASAT.po_distribution_id = POD.po_distribution_id(+)

Line 2580: from AP_SELF_ASSESSED_TAX_DIST_ALL APSAT

2576: where apd.invoice_distribution_id = apext.aid_invoice_dist_id
2577: and ((APD.PREPAY_DISTRIBUTION_ID is null and P_MODE <>'C') or P_MODE ='C' ))
2578: OR exists ( /* BUG 14216205 : Added the following Code for SAT : Starts */
2579: select 1
2580: from AP_SELF_ASSESSED_TAX_DIST_ALL APSAT
2581: where APSAT.INVOICE_DISTRIBUTION_ID = APEXT.AID_INVOICE_DIST_ID
2582: and ((APSAT.PREPAY_DISTRIBUTION_ID is null and P_MODE <>'C') or P_MODE ='C' ))
2583: ) /* BUG 14216205 : Added the following Code for SAT : Ends */
2584: /* Bug 5645290 - End */

Line 2781: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,

2777: and APSAT.PARENT_REVERSAL_ID is not null
2778: AND adl1.award_set_id = apt.award_id
2779: AND adl1.adl_line_num =1 ) burdenable_raw_cost ,
2780: apsat.PARENT_REVERSAL_ID PARENT_REVERSAL_ID
2781: FROM AP_SELF_ASSESSED_TAX_DIST_ALL apsat,
2782: ap_invoices_all api,
2783: gms_award_distributions adl,
2784: PA_EXPENDITURE_TYPES ET
2785: WHERE apsat.invoice_distribution_id = p_ap_dist_id

Line 8421: AP_SELF_ASSESSED_TAX_DIST_ALL apsat

8417: and NVL(apd.pa_addition_flag,'X') = 'T'
8418: union /* BUG 14216205 : Added the union for SAT */
8419: select a.bc_packet_id
8420: from GMS_BC_PACKETS a,
8421: AP_SELF_ASSESSED_TAX_DIST_ALL apsat
8422: where a.packet_id = x_packet_id
8423: and a.DOCUMENT_TYPE = 'AP'
8424: and a.DOCUMENT_HEADER_ID = APSAT.INVOICE_ID
8425: and a.DOCUMENT_DISTRIBUTION_ID = APSAT.DISTRIBUTION_LINE_NUMBER