DBA Data[Home] [Help]

APPS.PAY_GB_ENROLL_PENSION dependencies on PAY_ALL_PAYROLLS_F

Line 3224: FROM pay_all_payrolls_f ppf,

3220: -- Cursor to get Pension Scheme Name at Payroll Level if any
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;

Line 4171: FROM pay_all_payrolls_f ppf,

4167: -- to get pensions staging date at Payroll level
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;