APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_APPLICATION_SET_COMPS_V

Line 618: hxc_application_set_comps_v has

614: -- Cursor to pick up all application sets for this process.
615: CURSOR get_app_sets ( p_process VARCHAR2)
616: IS SELECT has.application_set_id
617: FROM hxc_retrieval_processes hrp,
618: hxc_application_set_comps_v has
619: WHERE hrp.name = DECODE(p_process,
620: 'Apply Schedule Rules','BEE Retrieval Process',
621: p_process)
622: AND hrp.time_recipient_id = has.time_recipient_id;

Line 7920: FROM hxc_application_set_comps_v

7916: p_ret_tr_id_2 NUMBER
7917: )
7918: IS
7919: SELECT DISTINCT application_set_id
7920: FROM hxc_application_set_comps_v
7921: WHERE time_recipient_id IN
7922: (p_ret_tr_id_1, p_ret_tr_id_2);
7923:
7924: CURSOR csr_get_tr_id (p_application_id NUMBER)