APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_TIME_RECIPIENTS

Line 55: in hxc_time_recipients.time_recipient_id%type,

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

Line 57: in hxc_time_recipients.application_retrieval_function%type)

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

Line 96: from hxc_time_recipients tr,

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

Line 545: from hxc_time_recipients

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