DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on RCV_TRANSACTIONS

Line 3128: FROM rcv_transactions_interface rti

3124: l_count_rows := 0;
3125:
3126: SELECT count(1)
3127: INTO l_count_rows
3128: FROM rcv_transactions_interface rti
3129: WHERE rti.to_organization_code IN
3130: (SELECT ood.organization_code
3131: FROM cst_organization_definitions ood
3132: WHERE CST_PAC_ITERATION_PROCESS_PVT.Check_Cst_Group_Org(ood.organization_id) = 'Y'

Line 3219: FROM rcv_transactions rt

3215: l_count_rows := 0;
3216:
3217: SELECT count(1)
3218: INTO l_count_rows
3219: FROM rcv_transactions rt
3220: WHERE rt.creation_date > (SELECT MIN(cppp.process_date)
3221: FROM cst_pac_process_phases cppp
3222: WHERE
3223: ( (cppp.process_phase <= 4 OR cppp.process_phase = 7)