APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 237: UPDATE ap_self_assessed_tax_dist_all

233: WHERE invoice_id = p_invoice_id
234: AND bc_event_id=rec_event.event_id
235: AND nvl(encumbered_flag,'N') <> 'Y';
236:
237: UPDATE ap_self_assessed_tax_dist_all
238: SET bc_event_id=NULL
239: WHERE invoice_id = p_invoice_id
240: AND bc_event_id=rec_event.event_id
241: AND nvl(encumbered_flag,'N') <> 'Y';

Line 854: ap_self_assessed_tax_dist_all T

850: NULL, --status_code
851: T.self_assessed_flag --self_assessed_flag --bug7109594
852: FROM gl_period_statuses PER,
853: ap_invoices I,
854: ap_self_assessed_tax_dist_all T
855: WHERE T.invoice_id = I.invoice_id
856: AND T.posted_flag in ('N', 'P')
857: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')
858: AND T.period_name = PER.period_name

Line 895: ap_self_assessed_tax_dist_all T

891: NULL, --status_code
892: T.self_assessed_flag --self_assessed_flag --bug7109594
893: FROM gl_period_statuses PER,
894: ap_invoices I,
895: ap_self_assessed_tax_dist_all T
896: WHERE T.invoice_id = I.invoice_id
897: AND T.posted_flag in ('N', 'P')
898: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')
899: AND T.period_name = PER.period_name

Line 1417: UPDATE ap_self_assessed_tax_dist_all sad

1413: AND aid.bc_event_id is not null;
1414:
1415: ELSE
1416:
1417: UPDATE ap_self_assessed_tax_dist_all sad
1418: SET sad.encumbered_flag = 'Y'
1419: WHERE sad.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id
1420: AND sad.bc_event_id is not null;
1421:

Line 1533: UPDATE ap_self_assessed_tax_dist_all sad

1529: AND aid.bc_event_id is not null;
1530:
1531: ELSE
1532:
1533: UPDATE ap_self_assessed_tax_dist_all sad
1534: SET sad.encumbered_flag = 'Y'
1535: WHERE sad.invoice_distribution_id = t_funds_dist_tab(i).inv_distribution_id
1536: AND sad.bc_event_id is not null;
1537:

Line 2773: FROM ap_self_assessed_tax_dist_all t,

2769: T.org_id, -- org_id
2770: NULL, --result_code
2771: NULL, --status_code
2772: T.self_assessed_flag --self_assessed_flag --bug7109594
2773: FROM ap_self_assessed_tax_dist_all t,
2774: ap_invoices_all ai,
2775: gl_period_statuses per
2776: WHERE ai.invoice_id = p_invoice_id
2777: AND t.invoice_id = ai.invoice_id

Line 2807: FROM ap_self_assessed_tax_dist_all t,

2803: T.org_id, -- org_id
2804: NULL, -- result_code
2805: NULL, -- status_code
2806: T.self_assessed_flag -- self_assessed_flag --bug7109594
2807: FROM ap_self_assessed_tax_dist_all t,
2808: ap_invoices_all ai,
2809: gl_period_statuses per
2810: WHERE ai.invoice_id = p_invoice_id
2811: AND t.invoice_id = ai.invoice_id