DBA Data[Home] [Help]

APPS.PSA_UTILS dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 1227: debug_other_string(g_state_level,l_path_name, 'Updating ap_self_assessed_tax_dist_all');

1223: and fc_status ='A';
1224:
1225: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1226:
1227: debug_other_string(g_state_level,l_path_name, 'Updating ap_self_assessed_tax_dist_all');
1228:
1229: UPDATE ap_self_assessed_tax_dist_all sad
1230: SET bc_event_id = null,
1231: accounting_event_id = decode(p_mode , 'A' , NULL,accounting_event_id)

Line 1229: UPDATE ap_self_assessed_tax_dist_all sad

1225: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1226:
1227: debug_other_string(g_state_level,l_path_name, 'Updating ap_self_assessed_tax_dist_all');
1228:
1229: UPDATE ap_self_assessed_tax_dist_all sad
1230: SET bc_event_id = null,
1231: accounting_event_id = decode(p_mode , 'A' , NULL,accounting_event_id)
1232: WHERE sad.invoice_id = p_invoice_id
1233: AND sad.invoice_distribution_id in (select invoice_distribution_id