APPS.AP_APPROVAL_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 2165: UPDATE ap_self_assessed_tax_dist_all D

2161: AND D.invoice_line_number = p_line_number;
2162:
2163:
2164: --Bug 6963908
2165: UPDATE ap_self_assessed_tax_dist_all D
2166: SET match_status_flag = 'S'
2167: WHERE NVL(match_status_flag, 'N') = 'N'
2168: AND D.invoice_id = p_invoice_id
2169: AND D.invoice_line_number = p_line_number;

Line 2183: UPDATE ap_self_assessed_tax_dist_all D

2179: WHERE NVL(match_status_flag, '!') <> 'A'
2180: AND D.invoice_id = p_invoice_id;
2181:
2182: --Bug 6963908
2183: UPDATE ap_self_assessed_tax_dist_all D
2184: SET match_status_flag = 'S'
2185: WHERE NVL(match_status_flag, '!') <> 'A'
2186: AND D.invoice_id = p_invoice_id;
2187: --Bug 6963908

Line 4747: UPDATE ap_self_assessed_tax_dist_all D

4743: WHERE match_status_flag = 'S'
4744: AND D.invoice_id = p_invoice_id;
4745:
4746: --Bug6963908
4747: UPDATE ap_self_assessed_tax_dist_all D
4748: SET match_status_flag = 'T',
4749: last_update_date = SYSDATE,
4750: last_updated_by = p_user_id,
4751: program_application_id = decode(fnd_global.prog_appl_id,

Line 4800: UPDATE ap_self_assessed_tax_dist_all D

4796: (nvl(D.encumbered_flag, 'N') in ('Y','W','D','X','R')))); -- BUG 4340061
4797:
4798:
4799: --Bug6963908
4800: UPDATE ap_self_assessed_tax_dist_all D
4801: SET match_status_flag = 'A',
4802: packet_id = ''
4803: WHERE match_status_flag = 'T'
4804: AND D.invoice_id = p_invoice_id