APPS.PSA_AP_BC_PVT dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 457: FROM ap_self_assessed_tax_dist_all aps

453: AND NOT EXISTS (SELECT 'not exists'
454: FROM ap_prepay_app_dists apd
455: WHERE apd.bc_event_id = xe.event_id)
456: AND NOT EXISTS (SELECT 'not exists'
457: FROM ap_self_assessed_tax_dist_all aps
458: WHERE aps.bc_event_id = xe.event_id)
459: ORDER BY xe.event_id;
460: BEGIN
461: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_Processed_Orphan_Events');

Line 1122: UPDATE ap_self_assessed_tax_dist_all sad

1118: AND aid.invoice_line_number = p_tab_fc_dist(i).inv_line_num
1119: AND aid.invoice_distribution_id = p_tab_fc_dist(i).inv_distribution_id;
1120: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows updated of ap_invoice_distributions_all: ' || SQL%ROWCOUNT);
1121: ELSE -- added by KS
1122: UPDATE ap_self_assessed_tax_dist_all sad
1123: SET bc_event_id = l_event_id
1124: WHERE sad.invoice_id = p_tab_fc_dist(i).invoice_id
1125: AND sad.invoice_line_number = p_tab_fc_dist(i).inv_line_num
1126: AND sad.invoice_distribution_id = p_tab_fc_dist(i).inv_distribution_id;