APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 702: ap_self_assessed_tax_dist_all T

698: NULL, --status_code
699: T.self_assessed_flag --self_assessed_flag --bug7109594
700: FROM gl_period_statuses PER,
701: ap_invoices I,
702: ap_self_assessed_tax_dist_all T
703: WHERE T.invoice_id = I.invoice_id
704: AND T.posted_flag in ('N', 'P')
705: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')
706: AND T.period_name = PER.period_name

Line 742: ap_self_assessed_tax_dist_all T

738: NULL, --status_code
739: T.self_assessed_flag --self_assessed_flag --bug7109594
740: FROM gl_period_statuses PER,
741: ap_invoices I,
742: ap_self_assessed_tax_dist_all T
743: WHERE T.invoice_id = I.invoice_id
744: AND T.posted_flag in ('N', 'P')
745: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')
746: AND T.period_name = PER.period_name

Line 1148: UPDATE ap_self_assessed_tax_dist_all sad

1144: AND bc_event_id is not null ;
1145:
1146: ELSE
1147:
1148: UPDATE ap_self_assessed_tax_dist_all sad
1149: SET encumbered_flag = 'Y'
1150: WHERE sad.invoice_distribution_id =
1151: t_funds_dist_tab(i).inv_distribution_id
1152: AND sad.bc_event_id is not null ;

Line 1213: UPDATE ap_self_assessed_tax_dist_all sad

1209: AND bc_event_id is not null ;
1210:
1211: ELSE
1212:
1213: UPDATE ap_self_assessed_tax_dist_all sad
1214: SET encumbered_flag = 'Y'
1215: WHERE sad.invoice_distribution_id =
1216: t_funds_dist_tab(i).inv_distribution_id
1217: AND sad.bc_event_id is not null ;

Line 2368: FROM ap_self_assessed_tax_dist_all t,

2364: T.org_id, -- org_id
2365: NULL, --result_code
2366: NULL, --status_code
2367: T.self_assessed_flag --self_assessed_flag --bug7109594
2368: FROM ap_self_assessed_tax_dist_all t,
2369: ap_invoices_all ai,
2370: gl_period_statuses per
2371: WHERE ai.invoice_id = p_invoice_id
2372: AND t.invoice_id = ai.invoice_id

Line 2402: FROM ap_self_assessed_tax_dist_all t,

2398: T.org_id, -- org_id
2399: NULL, -- result_code
2400: NULL, -- status_code
2401: T.self_assessed_flag -- self_assessed_flag --bug7109594
2402: FROM ap_self_assessed_tax_dist_all t,
2403: ap_invoices_all ai,
2404: gl_period_statuses per
2405: WHERE ai.invoice_id = p_invoice_id
2406: AND t.invoice_id = ai.invoice_id