APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 58: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

54: FUNCTION batches_created
55: RETURN batches_type_table;
56:
57: FUNCTION where_clause (
58: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
59: p_location_id IN per_all_assignments_f.location_id%TYPE,
60: p_payroll_id IN per_all_assignments_f.payroll_id%TYPE,
61: p_organization_id IN per_all_assignments_f.organization_id%TYPE,
62: p_person_id IN per_all_people_f.person_id%TYPE,

Line 68: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

64: )
65: RETURN VARCHAR2;
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,

Line 84: p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

80: p_no_otm IN OUT NOCOPY hxt_interface_utilities.flag_varchar
81: );
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,

Line 175: PROCEDURE make_adjustments_otm( p_bg_id IN hr_all_organization_units.business_group_id%TYPE,

171: p_session_date IN DATE
172: ) ;
173:
174:
175: PROCEDURE make_adjustments_otm( p_bg_id IN hr_all_organization_units.business_group_id%TYPE,
176: p_batch_ref IN VARCHAR2) ;
177:
178: TYPE r_bb_details IS
179: RECORD (