APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PQP_UTILITIES

Line 26: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;

22: g_active_asg_sts_id NUMBER;
23: g_terminate_asg_sts_id NUMBER;
24: g_event_counter NUMBER;
25: g_assignment_id NUMBER;
26: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;
27: g_person_id NUMBER;
28: g_min_effective_date DATE;
29: g_min_eff_date_exists VARCHAR2(10);
30: g_effective_start_date DATE;

Line 133: g_tab_event_map_cv pqp_utilities.t_config_values;

129:
130: TYPE t_lookups IS TABLE OF r_lookup_code
131: INDEX BY BINARY_INTEGER;
132:
133: g_tab_event_map_cv pqp_utilities.t_config_values;
134: g_tab_pen_sch_map_cv pqp_utilities.t_config_values;
135: g_tab_emp_typ_map_cv pqp_utilities.t_config_values;
136: g_tab_abs_types t_number;
137: g_tab_asg_status t_number;

Line 134: g_tab_pen_sch_map_cv pqp_utilities.t_config_values;

130: TYPE t_lookups IS TABLE OF r_lookup_code
131: INDEX BY BINARY_INTEGER;
132:
133: g_tab_event_map_cv pqp_utilities.t_config_values;
134: g_tab_pen_sch_map_cv pqp_utilities.t_config_values;
135: g_tab_emp_typ_map_cv pqp_utilities.t_config_values;
136: g_tab_abs_types t_number;
137: g_tab_asg_status t_number;
138: g_tab_pen_ele_ids t_element_details;

Line 135: g_tab_emp_typ_map_cv pqp_utilities.t_config_values;

131: INDEX BY BINARY_INTEGER;
132:
133: g_tab_event_map_cv pqp_utilities.t_config_values;
134: g_tab_pen_sch_map_cv pqp_utilities.t_config_values;
135: g_tab_emp_typ_map_cv pqp_utilities.t_config_values;
136: g_tab_abs_types t_number;
137: g_tab_asg_status t_number;
138: g_tab_pen_ele_ids t_element_details;
139: g_tab_prs_dfn_cv pqp_utilities.t_config_values;

Line 139: g_tab_prs_dfn_cv pqp_utilities.t_config_values;

135: g_tab_emp_typ_map_cv pqp_utilities.t_config_values;
136: g_tab_abs_types t_number;
137: g_tab_asg_status t_number;
138: g_tab_pen_ele_ids t_element_details;
139: g_tab_prs_dfn_cv pqp_utilities.t_config_values;
140: g_tab_event_desc_lov t_lookups;
141: g_person_dtl per_all_people_f%ROWTYPE;
142: g_assignment_dtl per_all_assignments_f%ROWTYPE;
143: g_tab_dated_table t_dated_table;

Line 147: g_tab_lvrsn_map_cv pqp_utilities.t_config_values;

143: g_tab_dated_table t_dated_table;
144: g_tab_pay_proc_evnts ben_ext_person.t_detailed_output_table;
145: g_tab_event_group t_event_group;
146: g_prev_pay_proc_evnts ben_ext_person.t_detailed_output_tab_rec;
147: g_tab_lvrsn_map_cv pqp_utilities.t_config_values;
148:
149: -- Cursor to fetch sickness pay transition from
150: -- summary tables
151: CURSOR csr_chk_pay_trans(