APPS.PAY_GB_ENROLL_PENSION dependencies on HR_SOFT_CODING_KEYFLEX

Line 701: HR_SOFT_CODING_KEYFLEX HSCF,

697: NVL(UPPER(SUBSTR(LTRIM(HOI.ORG_INFORMATION3),1,35)),'NONE') WORKER_POSTPONEMENT_RULE,
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'

Line 3225: hr_soft_coding_keyflex scl

3221: CURSOR C_GET_PAYROLL_PENSION_INFO
3222: IS
3223: SELECT scl.SEGMENT19
3224: FROM pay_all_payrolls_f ppf,
3225: hr_soft_coding_keyflex scl
3226: WHERE ppf.payroll_id =G_PAYROLL_ID
3227: AND scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
3228: AND G_PRP_END_DATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
3229: ------------------------------------------------------------------------------------------

Line 4172: hr_soft_coding_keyflex scl

4168: CURSOR C_PAYROLL_PENSION_STAGING_DATE
4169: IS
4170: SELECT scl.SEGMENT20
4171: FROM pay_all_payrolls_f ppf,
4172: hr_soft_coding_keyflex scl
4173: WHERE ppf.payroll_id =G_PAYROLL_ID
4174: AND scl.soft_coding_keyflex_id = ppf.soft_coding_keyflex_id
4175: AND G_PRP_END_DATE BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4176:

Line 4190: HR_SOFT_CODING_KEYFLEX HSCF,

4186: CURSOR C_PAYEE_PENSION_STAGING_DATE
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'