DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on XLA_DISTRIBUTION_LINKS

Line 1256: xla_distribution_links xdl,

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
1260: AND xdl.source_distribution_id_num_1 = APAD.Prepay_App_Dist_ID

Line 1283: xla_distribution_links xdl

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
1287: AND p.source_distribution_id_num_1 = xdl.source_distribution_id_num_1