APPS.PAY_GB_ENROLL_PENSION dependencies on HR_ORGANIZATION_INFORMATION

Line 702: HR_ORGANIZATION_INFORMATION HOI

698: NVL(UPPER(SUBSTR(LTRIM(HOI.ORG_INFORMATION4),1,35)),'NONE') ELIGIBLE_POSPONEMENT_RULE,
699: PPF.PERIOD_TYPE
700: FROM PAY_PAYROLLS_F PPF,
701: HR_SOFT_CODING_KEYFLEX HSCF,
702: HR_ORGANIZATION_INFORMATION HOI
703: WHERE PPF.PAYROLL_ID = P_PAYROLL_ID
704: AND PPF.BUSINESS_GROUP_ID = HOI.ORGANIZATION_ID
705: AND HOI.ORG_INFORMATION_CONTEXT = 'UK Pensions'
706: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'

Line 4191: HR_ORGANIZATION_INFORMATION HOI

4187: IS
4188: SELECT UPPER(SUBSTR(TRIM(HOI.ORG_INFORMATION2),1,35)) PENSION_STAGING_DATE
4189: FROM PAY_PAYROLLS_F PPF,
4190: HR_SOFT_CODING_KEYFLEX HSCF,
4191: HR_ORGANIZATION_INFORMATION HOI
4192: WHERE PPF.PAYROLL_ID = G_PAYROLL_ID
4193: AND PPF.BUSINESS_GROUP_ID = HOI.ORGANIZATION_ID
4194: AND HOI.ORG_INFORMATION_CONTEXT = 'UK Pensions'
4195: AND NVL(HOI.ORG_INFORMATION10,'UK') = 'UK'

Line 4266: L_PENSION_STAGING_DATE_TEMP HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE; -- bug 16178067

4262: l_qps_on_staging_date PQP_GB_PENSION_SCHEMES_V.ELEMENT_NAME%TYPE :=NULL;
4263: --Bug 14649941
4264: L_EARNINGS_OLD NUMBER :=0; -- bug 16102066
4265: L_EMPLOYEE_PENSION_CLASS_OLD VARCHAR2(100) :=NULL;--bug 16102066
4266: L_PENSION_STAGING_DATE_TEMP HR_ORGANIZATION_INFORMATION.ORG_INFORMATION2%TYPE; -- bug 16178067
4267: -- bug 14380856
4268: --Bug 16394694
4269: l_asg_start_date Date;
4270: --Bug 16394694