APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_RECIPIENTS

Line 7927: FROM hxc_time_recipients tr

7923:
7924: CURSOR csr_get_tr_id (p_application_id NUMBER)
7925: IS
7926: SELECT tr.time_recipient_id
7927: FROM hxc_time_recipients tr
7928: WHERE tr.application_id = p_application_id;
7929:
7930: l_application_set_id_string VARCHAR2 (200) := '';
7931: l_ret_tr_id NUMBER := p_retrieval_tr_id;

Line 7932: l_hr_tr hxc_time_recipients.time_recipient_id%TYPE;

7928: WHERE tr.application_id = p_application_id;
7929:
7930: l_application_set_id_string VARCHAR2 (200) := '';
7931: l_ret_tr_id NUMBER := p_retrieval_tr_id;
7932: l_hr_tr hxc_time_recipients.time_recipient_id%TYPE;
7933: l_ret_tr_id_1 NUMBER := p_retrieval_tr_id;
7934: l_ret_tr_id_2 NUMBER := NULL;
7935: BEGIN
7936: -- if the process is BEE retrieval process then we need to add the application set ids of