DBA Data[Home] [Help]

APPS.CSTPPPSC dependencies on RCV_TRANSACTIONS

Line 979: FROM rcv_transactions rt

975: l_closing_pac_period_id NUMBER,
976: l_entity_id NUMBER,
977: l_cost_type_id NUMBER) IS
978: SELECT count(1)
979: FROM rcv_transactions rt
980: WHERE rt.creation_date > ( SELECT MIN(cppp.process_date)
981: FROM cst_pac_process_phases cppp
982: WHERE
983: (( cppp.process_phase <= 5

Line 1183: FROM rcv_transactions_interface rti

1179: /* **************************************************************************** */
1180:
1181: CURSOR cur_rti(l_current_cost_group_id NUMBER,l_closing_pac_period_id NUMBER) IS
1182: SELECT count(1)
1183: FROM rcv_transactions_interface rti
1184: WHERE rti.to_organization_code IN
1185: (select mp.organization_code
1186: from cst_cost_group_assignments ccga,
1187: mtl_parameters mp