APPS.PAY_ES_SS_CALCULATION dependencies on HR_ALL_ORGANIZATION_UNITS

Line 411: ,hr_all_organization_units hou

407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
414: AND hoi.org_information1 = c_work_center
415: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'

Line 726: l_legal_employer_id hr_All_organization_units.organization_id%TYPE;

722: l_ctr NUMBER;
723: l_cnt NUMBER;
724: l_start_date DATE;
725: l_date DATE;
726: l_legal_employer_id hr_All_organization_units.organization_id%TYPE;
727: --
728: BEGIN
729: --
730: hr_utility.trace('~~Entering pay_es_ss_calculation.get_prev_salary');

Line 1678: l_legal_employer_id hr_All_organization_units.organization_id%TYPE;

1674: l_amount NUMBER;
1675: l_ctr NUMBER;
1676: l_cnt NUMBER;
1677: l_start_date DATE;
1678: l_legal_employer_id hr_All_organization_units.organization_id%TYPE;
1679: l_amt NUMBER;
1680: l_date DATE;
1681: l_days NUMBER;
1682: --