APPS.PSA_UTILS dependencies on GMS_AWARD_DISTRIBUTIONS

Line 301: SELECT * FROM GMS_AWARD_DISTRIBUTIONS WHERE INVOICE_DISTRIBUTION_ID IN (

297:
298: IF (p_retcode = g_SUCCESS) THEN
299: BEGIN
300: l_string := 'CREATE TABLE PSA_BKP_GMS_DISTS_'||l_backup_string||' AS
301: SELECT * FROM GMS_AWARD_DISTRIBUTIONS WHERE INVOICE_DISTRIBUTION_ID IN (
302: SELECT INVOICE_DISTRIBUTION_ID
303: FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID = '||p_entity_rec.source_id_int_1||
304: ')';
305: EXECUTE IMMEDIATE l_string;

Line 1215: debug_other_string(g_state_level,l_path_name, 'Updating gms_award_distributions' );

1211: AND NVL(encumbered_flag,'X') <> 'R';
1212: debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
1213:
1214:
1215: debug_other_string(g_state_level,l_path_name, 'Updating gms_award_distributions' );
1216:
1217: update gms_award_distributions
1218: set fc_status = 'N'
1219: where invoice_distribution_id in (select invoice_distribution_id

Line 1217: update gms_award_distributions

1213:
1214:
1215: debug_other_string(g_state_level,l_path_name, 'Updating gms_award_distributions' );
1216:
1217: update gms_award_distributions
1218: set fc_status = 'N'
1219: where invoice_distribution_id in (select invoice_distribution_id
1220: from ap_invoice_distributions_all
1221: where invoice_id = p_invoice_id