eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSA_AP_BC_PVT dependencies on GL_BC_PACKETS

Line 774: gl_bc_packets p,

770: min(p.status_code)
771: INTO p_tab_fc_dist(i).result_code,
772: p_tab_fc_dist(i).status_code
773: FROM psa_bc_xla_events_gt e,
774: gl_bc_packets p,
775: xla_distribution_links xdl,
776: ap_prepay_app_dists apad
777: WHERE xdl.event_id = e.event_id
778: AND apad.PREPAY_APP_DISTRIBUTION_ID = p_tab_fc_dist(i).inv_distribution_id

Line 797: gl_bc_packets p,

793: min(p.status_code)
794: INTO p_tab_fc_dist(i).result_code,
795: p_tab_fc_dist(i).status_code
796: FROM psa_bc_xla_events_gt e,
797: gl_bc_packets p,
798: xla_distribution_links xdl
799: WHERE xdl.event_id = e.event_id
800: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id
801: AND p.event_id = xdl.event_id

Line 936: FROM gl_bc_packets bc,

932: INTO p_fc_result_code
933: FROM gl_lookups l
934: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
935: AND EXISTS ( SELECT 'x'
936: FROM gl_bc_packets bc,
937: psa_bc_xla_events_gt e
938: WHERE bc.event_id = e.event_id
939: AND bc.result_code like 'F%'
940: AND bc.result_code = l.lookup_code