DBA Data[Home] [Help]

APPS.PAY_GB_FPS_NI_AND_OTHERS dependencies on HR_SOFT_CODING_KEYFLEX

Line 2262: ,hr_soft_coding_keyflex FLEX

2258: to_date('01/01/0001','DD/MM/YYYY'))
2259: from per_assignments_f ASS
2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2264: ,hr_soft_coding_keyflex PFLEX
2265: where ASS.assignment_id = BAL_ASSACT.assignment_id
2266: and NROLL.payroll_id = ASS.payroll_id

Line 2264: ,hr_soft_coding_keyflex PFLEX

2260: ,per_assignments_f PASS /* previous assignment */
2261: ,pay_payrolls_f NROLL
2262: ,hr_soft_coding_keyflex FLEX
2263: ,pay_payrolls_f PROLL
2264: ,hr_soft_coding_keyflex PFLEX
2265: where ASS.assignment_id = BAL_ASSACT.assignment_id
2266: and NROLL.payroll_id = ASS.payroll_id
2267: and ASS.effective_start_date between
2268: NROLL.effective_start_date and NROLL.effective_end_date

Line 3208: hr_soft_coding_keyflex flex,

3204: SELECT paaf.business_group_id,
3205: flex.segment1
3206: FROM pay_assignment_actions paa,
3207: per_all_assignments_f paaf,
3208: hr_soft_coding_keyflex flex,
3209: pay_payrolls_f ppf,
3210: pay_payroll_actions ppa
3211: WHERE ppa.payroll_action_id = L_PAYROLL_ACTION_ID
3212: AND paa.payroll_action_id = ppa.payroll_action_id