APPS.AP_APPROVAL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 2986: UPDATE ap_self_assessed_tax_dist_all D

2982: AND D.invoice_line_number = p_line_number;
2983:
2984:
2985: --Bug 6963908
2986: UPDATE ap_self_assessed_tax_dist_all D
2987: SET match_status_flag = 'S'
2988: WHERE NVL(match_status_flag, 'N') = 'N'
2989: AND NVL(D.posted_flag, 'N' ) = 'N' -- Bug 9777752
2990: AND D.invoice_id = p_invoice_id

Line 3013: UPDATE ap_self_assessed_tax_dist_all D

3009: AND NVL(D.posted_flag, 'N' ) = 'N' -- Bug 9777752
3010: AND D.invoice_id = p_invoice_id;
3011:
3012: --Bug 6963908
3013: UPDATE ap_self_assessed_tax_dist_all D
3014: SET match_status_flag = 'S'
3015: WHERE NVL(match_status_flag, '!') <> 'A'
3016: AND NVL(D.posted_flag, 'N' ) = 'N' -- Bug 9777752
3017: AND D.invoice_id = p_invoice_id;

Line 5422: FROM ap_self_assessed_tax_dist_all ast

5418: if(l_null_event_id = 0) then
5419:
5420: SELECT count(*)
5421: INTO l_null_event_id_self
5422: FROM ap_self_assessed_tax_dist_all ast
5423: WHERE ast.invoice_id = P_invoice_id
5424: AND ast.accounting_event_id is NULL
5425: AND rownum = 1;
5426:

Line 6278: UPDATE ap_self_assessed_tax_dist_all D

6274: WHERE match_status_flag = 'S'
6275: AND D.invoice_id = p_invoice_id;
6276:
6277: --Bug6963908
6278: UPDATE ap_self_assessed_tax_dist_all D
6279: SET match_status_flag = 'T',
6280: last_update_date = SYSDATE,
6281: last_updated_by = p_user_id,
6282: program_application_id = decode(fnd_global.prog_appl_id,

Line 6338: UPDATE ap_self_assessed_tax_dist_all D

6334: (nvl(D.encumbered_flag, 'N') in ('Y','W','D','X','R')))); -- BUG 4340061
6335:
6336:
6337: --Bug6963908
6338: UPDATE ap_self_assessed_tax_dist_all D
6339: SET match_status_flag = 'A',
6340: packet_id = ''
6341: WHERE match_status_flag = 'T'
6342: AND D.invoice_id = p_invoice_id

Line 9819: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D,

9815: AND (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''Y'' AND NVL(D.MATCH_STATUS_FLAG,''N'') <> ''A'' OR
9816: (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''N'' AND NVL(D.MATCH_STATUS_FLAG,''N'') NOT IN (''A'',''T'')))
9817: UNION ALL
9818: SELECT 1
9819: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D,
9820: FINANCIALS_SYSTEM_PARAMS_ALL FSP
9821: WHERE D.INVOICE_ID = AI.INVOICE_ID
9822: AND FSP.ORG_ID = AI.ORG_ID
9823: AND FSP.SET_OF_BOOKS_ID = AI.SET_OF_BOOKS_ID

Line 9828: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D2

9824: AND (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''Y'' AND NVL(D.MATCH_STATUS_FLAG,''N'') <> ''A'' OR
9825: (NVL(FSP.PURCH_ENCUMBRANCE_FLAG,''N'') = ''N'' AND NVL(D.MATCH_STATUS_FLAG,''N'') NOT IN (''A'',''T'')))
9826: AND NOT EXISTS
9827: ( SELECT ''Cancelled distributions''
9828: FROM AP_SELF_ASSESSED_TAX_DIST_ALL D2
9829: WHERE D2.INVOICE_ID = D.INVOICE_ID
9830: AND D2.CANCELLATION_FLAG = ''Y''
9831: )
9832: UNION ALL