APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_INFORMATION

Line 67: FROM hr_organization_information

63: ) IS
64: SELECT org_information1 lea_number
65: ,org_information2 lea_name
66: ,nvl(org_information3,'N') CrossBG_Enabled
67: FROM hr_organization_information
68: WHERE organization_id = p_organization_id
69: AND org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO';*/
70:
71: -- ENH1 : added p_lea_number as parameter to fetch only the details of required LEA.

Line 86: FROM hr_organization_information hoi

82: ,DECODE(hoi.organization_id
83: ,p_organization_id, 0
84: ,hoi.organization_id) orgidcol -- added to Order by the result so that
85: -- the LEA at BG level comes first.
86: FROM hr_organization_information hoi
87: ,hr_organization_units hou
88: WHERE hoi.org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO'
89: AND hou.business_group_id = p_organization_id
90: AND hoi.organization_id = hou.organization_id

Line 107: ,hr_organization_information hoi

103: SELECT hoi.org_information1 lea_number
104: ,hoi.org_information2 lea_name
105: ,hoi.organization_id organization_id --Added for non-lea organizations.
106: FROM hr_organization_units_v org
107: ,hr_organization_information hoi
108: WHERE org.location_id = p_location_id
109: AND hoi.organization_id = org.organization_id
110: AND hoi.org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO';
111: --

Line 169: FROM hr_organization_information hoi

165: OR
166: ( lei.lei_information6 IS NULL -- LEA numebr in null at location EIT
167: AND
168: g_lea_number = (SELECT hoi.org_information1 --Find LEA Number at ORG level
169: FROM hr_organization_information hoi
170: WHERE hoi.org_information_context = 'PQP_GB_EDU_AUTH_LEA_INFO'
171: AND hoi.organization_id = NVL(p_business_group_id,g_business_group_id)
172: )
173: )