APPS.PER_HU_EMP_CERT_ARCHIVE dependencies on HR_ORGANIZATION_UNITS

Line 101: l_business_group_id hr_organization_units.business_group_id%type;

97: AND hou.location_id = addr.location_id (+)
98: ORDER BY hoi.organization_id ;
99:
100: -- Variables for storing company's address
101: l_business_group_id hr_organization_units.business_group_id%type;
102: l_ovn NUMBER;
103: l_action_info_id NUMBER;
104: l_start_date DATE;
105: l_end_date DATE;

Line 402: ,hr_organization_units hou

398: ,pay_element_entry_values_f eev
399: ,pay_input_values_f piv
400: ,pay_element_types_f pet
401: ,pay_element_type_extra_info pei
402: ,hr_organization_units hou
403: ,hr_locations_all addr
404: WHERE pee.element_entry_id = eev.element_entry_id
405: AND eev.input_value_id + 0 = piv.input_value_id
406: AND piv.element_type_id = pet.element_type_id

Line 504: TYPE t_vpp_name IS TABLE OF hr_organization_units.name%type INDEX BY BINARY_INTEGER;

500: l_total_sickness_holiday NUMBER;
501: l_account_no pay_external_accounts.segment2%TYPE;
502: l_absence_days NUMBER;
503:
504: TYPE t_vpp_name IS TABLE OF hr_organization_units.name%type INDEX BY BINARY_INTEGER;
505: l_vpp_name t_vpp_name;
506: lctr number;
507: --
508: BEGIN