APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_RECIPIENTS

Line 7029: FROM hxc_time_recipients tr

7025:
7026: CURSOR csr_get_tr_id (p_application_id NUMBER)
7027: IS
7028: SELECT tr.time_recipient_id
7029: FROM hxc_time_recipients tr
7030: WHERE tr.application_id = p_application_id;
7031:
7032: l_application_set_id_string VARCHAR2 (200) := '';
7033: l_ret_tr_id NUMBER := p_retrieval_tr_id;

Line 7034: l_hr_tr hxc_time_recipients.time_recipient_id%TYPE;

7030: WHERE tr.application_id = p_application_id;
7031:
7032: l_application_set_id_string VARCHAR2 (200) := '';
7033: l_ret_tr_id NUMBER := p_retrieval_tr_id;
7034: l_hr_tr hxc_time_recipients.time_recipient_id%TYPE;
7035: l_ret_tr_id_1 NUMBER := p_retrieval_tr_id;
7036: l_ret_tr_id_2 NUMBER := NULL;
7037: BEGIN
7038: -- if the process is BEE retrieval process then we need to add the application set ids of