APPS.PAY_NO_PAYPROC dependencies on HR_ORGANIZATION_UNITS

Line 139: from HR_ORGANIZATION_UNITS o1

135: where hsk.SOFT_CODING_KEYFLEX_ID = asg.SOFT_CODING_KEYFLEX_ID
136: and hsk.enabled_flag = 'Y'
137: and hsk.segment2 in (
138: select hoi2.org_information1
139: from HR_ORGANIZATION_UNITS o1
140: , HR_ORGANIZATION_INFORMATION hoi1
141: , HR_ORGANIZATION_INFORMATION hoi2
142: WHERE o1.business_group_id = pa1.business_group_id
143: and hoi1.organization_id = o1.organization_id

Line 804: from HR_ORGANIZATION_UNITS o

800: return varchar2 is
801:
802: cursor c_get_legal_emp_name is
803: select o.name
804: from HR_ORGANIZATION_UNITS o
805: WHERE o.business_group_id = p_business_group_id
806: and o.organization_id = to_number(p_legal_emp_id);
807:
808:

Line 809: l_legal_emp_name hr_organization_units.NAME%TYPE ;

805: WHERE o.business_group_id = p_business_group_id
806: and o.organization_id = to_number(p_legal_emp_id);
807:
808:
809: l_legal_emp_name hr_organization_units.NAME%TYPE ;
810:
811: begin
812:
813: