APPS.PAY_US_VALIDATE_INFO dependencies on HR_ORGANIZATION_INFORMATION

Line 22: from HR_ORGANIZATION_INFORMATION hoi

18: l_code := 1;
19:
20: select hoi.org_information1
21: into l_trans_flag
22: from HR_ORGANIZATION_INFORMATION hoi
23: where hoi.org_information_context = p_context
24: and hoi.org_information1 = 'Y'
25: and exists (select null
26: from hr_organization_information hoi1

Line 26: from hr_organization_information hoi1

22: from HR_ORGANIZATION_INFORMATION hoi
23: where hoi.org_information_context = p_context
24: and hoi.org_information1 = 'Y'
25: and exists (select null
26: from hr_organization_information hoi1
27: where hoi1.organization_id = hoi.organization_id
28: and hoi1.org_information_context = 'CLASS'
29: and hoi1.org_information1 = 'HR_LEGAL'
30: and hoi1.org_information2 = 'Y')

Line 57: from HR_ORGANIZATION_INFORMATION hoi

53:
54: cursor get_worksite is
55: select distinct hoi.org_information2,
56: hoi.org_information3
57: from HR_ORGANIZATION_INFORMATION hoi
58: where hoi.org_information_context = p_context
59: and exists (select null
60: from hr_organization_information hoi1
61: where hoi1.organization_id = hoi.organization_id

Line 60: from hr_organization_information hoi1

56: hoi.org_information3
57: from HR_ORGANIZATION_INFORMATION hoi
58: where hoi.org_information_context = p_context
59: and exists (select null
60: from hr_organization_information hoi1
61: where hoi1.organization_id = hoi.organization_id
62: and hoi1.org_information_context = 'CLASS'
63: and hoi1.org_information1 = 'HR_ESTAB'
64: and hoi1.org_information2 = 'Y')

Line 104: from HR_ORGANIZATION_INFORMATION hoi

100: SUI + RUN combination */
101:
102: select hoi.organization_id
103: into l_organization_id
104: from HR_ORGANIZATION_INFORMATION hoi
105: where hoi.org_information2 = l_sui_no
106: and hoi.org_information3 = l_run
107: and hoi.org_information1 = 'Y'
108: and hoi.org_information_context = p_context