DBA Data[Home] [Help]

APPS.RCV_PERSON dependencies on RCV_TRANSACTIONS

Line 60: from rcv_transactions rcv

56: into v_delete_permitted
57: from sys.dual
58: where not exists (
59: select null
60: from rcv_transactions rcv
61: where rcv.employee_id = P_PERSON_ID
62: or rcv.deliver_to_person_id = P_PERSON_ID)
63: and not exists (
64: select null

Line 65: from rcv_transactions_interface rcv

61: where rcv.employee_id = P_PERSON_ID
62: or rcv.deliver_to_person_id = P_PERSON_ID)
63: and not exists (
64: select null
65: from rcv_transactions_interface rcv
66: where rcv.employee_id = P_PERSON_ID
67: or rcv.deliver_to_person_id = P_PERSON_ID);
68: exception
69: when NO_DATA_FOUND then