APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PAY_ELEMENT_TYPES_F

Line 36: p_element_type_id pay_element_types_f.element_type_id%TYPE,

32: || (p_iv_number) Input Value of an Element Type without having to loop over
33: || all of them and then stop at the nth position.
34: */
35: CURSOR csr_iv_info (
36: p_element_type_id pay_element_types_f.element_type_id%TYPE,
37: p_iv_number PLS_INTEGER,
38: p_session_date DATE
39: )
40: IS

Line 46: pay_element_types_f etp

42: FROM (SELECT iv_data.*, ROWNUM r
43: FROM (SELECT inv.uom, inv.lookup_type, inv.value_set_id,
44: etp.input_currency_code
45: FROM pay_input_values_f inv,
46: pay_element_types_f etp
47: WHERE inv.element_type_id = p_element_type_id
48: AND etp.element_type_id = p_element_type_id
49: AND p_session_date
50: BETWEEN inv.effective_start_date

Line 595: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,

591: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
592: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
593: p_det_tbb_idx IN PLS_INTEGER,
594: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
595: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
596: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,
597: p_bee_rec IN OUT NOCOPY hxt_interface_utilities.bee_rec
598: )
599: AS