APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_TIME_RECIPIENTS

Line 57: in hxc_time_recipients.time_recipient_id%type,

53: end get_otm_app_attributes;
54:
55: Function find_retrieval_process_id
56: (p_time_recipient_id
57: in hxc_time_recipients.time_recipient_id%type,
58: p_retrieval_function
59: in hxc_time_recipients.application_retrieval_function%type)
60: Return number is
61:

Line 59: in hxc_time_recipients.application_retrieval_function%type)

55: Function find_retrieval_process_id
56: (p_time_recipient_id
57: in hxc_time_recipients.time_recipient_id%type,
58: p_retrieval_function
59: in hxc_time_recipients.application_retrieval_function%type)
60: Return number is
61:
62: c_ret_pro retrieval_ref_cursor;
63: l_sql VARCHAR2(32000);

Line 98: from hxc_time_recipients tr,

94: tr.name,
95: tr.application_retrieval_function,
96: tr.application_update_process,
97: tr.appl_validation_process
98: from hxc_time_recipients tr,
99: hxc_application_set_comps_v asc1
100: where p_application_set_id = asc1.application_set_id
101: and asc1.time_recipient_id = tr.time_recipient_id
102: and tr.application_retrieval_function is not null;

Line 547: from hxc_time_recipients

543: ) is
544:
545: cursor c_pa_tr_id is
546: select time_recipient_id
547: from hxc_time_recipients
548: where upper(name) = 'PROJECTS';
549:
550: l_application_set_id number;
551: l_elp_terg_id number;