APPS.PSA_AP_BC_PVT dependencies on GL_BC_PACKETS

Line 558: DELETE gl_bc_packets

554: orphan_event_rec.process_status_code||' '||
555: orphan_event_rec.gl_transfer_status_code||' '||
556: 'Success' );
557:
558: DELETE gl_bc_packets
559: WHERE event_id = orphan_event_rec.event_id;
560: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the gl_bc_packets'|| sql%rowcount);
561:
562: DELETE FROM xla_events

Line 560: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the gl_bc_packets'|| sql%rowcount);

556: 'Success' );
557:
558: DELETE gl_bc_packets
559: WHERE event_id = orphan_event_rec.event_id;
560: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the gl_bc_packets'|| sql%rowcount);
561:
562: DELETE FROM xla_events
563: WHERE event_id = orphan_event_rec.event_id;
564: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_events'|| sql%rowcount);

Line 1255: gl_bc_packets p,

1251: MIN(p.status_code)
1252: INTO p_tab_fc_dist(i).result_code,
1253: p_tab_fc_dist(i).status_code
1254: FROM psa_bc_xla_events_gt e,
1255: gl_bc_packets p,
1256: xla_distribution_links xdl,
1257: ap_prepay_app_dists apad
1258: WHERE xdl.event_id = e.event_id
1259: AND apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id

Line 1282: gl_bc_packets p,

1278: MIN(p.status_code)
1279: INTO p_tab_fc_dist(i).result_code,
1280: p_tab_fc_dist(i).status_code
1281: FROM psa_bc_xla_events_gt e,
1282: gl_bc_packets p,
1283: xla_distribution_links xdl
1284: WHERE xdl.event_id = e.event_id
1285: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id
1286: AND p.event_id = xdl.event_id

Line 1425: FROM gl_bc_packets bc,

1421: INTO p_fc_result_code
1422: FROM gl_lookups l
1423: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1424: AND EXISTS ( SELECT 'x'
1425: FROM gl_bc_packets bc,
1426: psa_bc_xla_events_gt e
1427: WHERE bc.event_id = e.event_id
1428: AND bc.result_code like 'F%'
1429: AND bc.result_code = l.lookup_code)