APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 70: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,

66:
67: PROCEDURE process_otlr_employees (
68: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
69: p_session_date IN DATE,
70: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,

Line 71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,

67: PROCEDURE process_otlr_employees (
68: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
69: p_session_date IN DATE,
70: p_start_date IN VARCHAR2, --hxc_time_building_blocks.start_time%TYPE,
71: p_end_date IN VARCHAR2, --hxc_time_building_blocks.stop_time%TYPE,
72: p_where_clause IN hxt_interface_utilities.max_varchar,
73: p_retrieval_transaction_code IN hxc_transactions.transaction_code%TYPE,
74: p_batch_ref IN pay_batch_headers.batch_reference%TYPE,
75: p_unique_params IN hxt_interface_utilities.max_varchar,

Line 86: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,

82:
83: PROCEDURE extract_data_from_attr_tbl (
84: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
85: p_attr_tbl IN hxc_generic_retrieval_pkg.t_time_attribute,
86: p_tbb_id IN hxc_time_building_blocks.time_building_block_id%TYPE,
87: p_det_tbb_idx IN PLS_INTEGER,
88: p_cost_flex_id IN per_business_groups_perf.cost_allocation_structure%TYPE,
89: p_effective_date IN pay_element_types_f.effective_start_date%TYPE,
90: p_attr_tbl_idx IN OUT NOCOPY PLS_INTEGER,