DBA Data[Home] [Help]

APPS.CSTPPPSC dependencies on RCV_TRANSACTIONS

Line 1038: FROM rcv_transactions rt

1034: l_closing_pac_period_id NUMBER,
1035: l_entity_id NUMBER,
1036: l_cost_type_id NUMBER) IS
1037: SELECT count(1)
1038: FROM rcv_transactions rt
1039: WHERE rt.creation_date > ( SELECT MIN(cppp.process_date)
1040: FROM cst_pac_process_phases cppp
1041: WHERE
1042: (( cppp.process_phase <= 5

Line 1242: FROM rcv_transactions_interface rti

1238: /* **************************************************************************** */
1239:
1240: CURSOR cur_rti(l_current_cost_group_id NUMBER,l_closing_pac_period_id NUMBER) IS
1241: SELECT count(1)
1242: FROM rcv_transactions_interface rti
1243: WHERE rti.to_organization_code IN
1244: (select mp.organization_code
1245: from cst_cost_group_assignments ccga,
1246: mtl_parameters mp