APPS.PAY_NO_PAYPROC dependencies on HR_ORGANIZATION_UNITS

Line 130: from HR_ORGANIZATION_UNITS o1

126: and hsk.SOFT_CODING_KEYFLEX_ID = asg.SOFT_CODING_KEYFLEX_ID
127: and hsk.enabled_flag = 'Y'
128: and hsk.segment2 in (
129: select hoi2.org_information1
130: from HR_ORGANIZATION_UNITS o1
131: , HR_ORGANIZATION_INFORMATION hoi1
132: , HR_ORGANIZATION_INFORMATION hoi2
133: WHERE o1.business_group_id = pa1.business_group_id
134: and hoi1.organization_id = o1.organization_id

Line 781: from HR_ORGANIZATION_UNITS o

777: return varchar2 is
778:
779: cursor c_get_legal_emp_name is
780: select o.name
781: from HR_ORGANIZATION_UNITS o
782: WHERE o.business_group_id = p_business_group_id
783: and o.organization_id = to_number(p_legal_emp_id);
784:
785:

Line 786: l_legal_emp_name hr_organization_units.NAME%TYPE ;

782: WHERE o.business_group_id = p_business_group_id
783: and o.organization_id = to_number(p_legal_emp_id);
784:
785:
786: l_legal_emp_name hr_organization_units.NAME%TYPE ;
787:
788: begin
789:
790: