DBA Data[Home] [Help]

APPS.PQP_GB_OSP_FUNCTIONS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 61: g_ssp_business_group_id hr_all_organization_units.business_group_id%TYPE;

57: --g_pattern_id hr_patterns.pattern_id%TYPE;
58:
59:
60: -- Cache for get_absence_ssp
61: g_ssp_business_group_id hr_all_organization_units.business_group_id%TYPE;
62: g_ssp_element_type_id pay_element_types_f.element_type_id%TYPE;
63: g_ssp_input_values t_input_value_ids;
64: g_ssp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
65: g_ssp_retro_input_values t_input_value_ids;

Line 76: g_smp_business_group_id hr_all_organization_units.business_group_id%TYPE;

72: g_smp_element_links t_element_links;
73: g_smp_retro_element_type_id pay_element_types_f.element_type_id%TYPE;
74: g_smp_retro_input_values t_input_value_ids;
75: g_smp_retro_element_links t_element_links;
76: g_smp_business_group_id hr_all_organization_units.business_group_id%TYPE;
77: g_absence_category VARCHAR2(30);
78: -- Cache for rounding of factors
79: /*check it absence round_to handle*/
80:

Line 229: g_ssp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;

225: --g_t_pat_cons.DELETE; --pat_cons_t
226: --g_pattern_id := NULL; --hr_patterns.pattern_id%TYPE
227:
228: -- Cache for get_absence_ssp
229: g_ssp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;
230:
231: g_ssp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
232: g_ssp_input_values.DELETE; --t_input_value_ids;
233: g_ssp_element_links.DELETE; --t_element_links;

Line 240: g_smp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;

236: g_ssp_retro_input_values.DELETE; --t_input_value_ids;
237: g_ssp_retro_element_links.DELETE; --t_element_links;
238:
239: -- Cache for get_absence_smp
240: g_smp_business_group_id := NULL; --hr_all_organization_units.business_group_id%TYPE;
241:
242: g_smp_element_type_id := NULL; --pay_element_types_f.element_type_id%TYPE;
243: g_smp_input_values.DELETE; --t_input_value_ids;
244: g_smp_element_links.DELETE; --t_element_links;