DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on RCV_TRANSACTIONS

Line 3183: FROM rcv_transactions_interface rti

3179: l_count_rows := 0;
3180:
3181: SELECT count(1)
3182: INTO l_count_rows
3183: FROM rcv_transactions_interface rti
3184: WHERE rti.to_organization_code IN
3185: (SELECT ood.organization_code
3186: FROM cst_organization_definitions ood
3187: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(ood.organization_id) = 'Y'

Line 3274: FROM rcv_transactions rt

3270: l_count_rows := 0;
3271:
3272: SELECT count(1)
3273: INTO l_count_rows
3274: FROM rcv_transactions rt
3275: WHERE rt.creation_date > (SELECT MIN(cppp.process_date)
3276: FROM cst_pac_process_phases cppp
3277: WHERE
3278: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)