DBA Data[Home] [Help]

APPS.PAY_GB_P11D_CAR_EXTRACT dependencies on HR_SOFT_CODING_KEYFLEX

Line 988: hr_soft_coding_keyflex flex

984: CURSOR get_asg_details(p_asg_id IN NUMBER) IS
985: SELECT pp.payroll_id, asg.person_id, pp.consolidation_set_id, flex.segment1 tax_dist
986: FROM pay_all_payrolls_f pp,
987: per_all_assignments_f asg,
988: hr_soft_coding_keyflex flex
989: WHERE asg.assignment_id = p_asg_id
990: AND asg.payroll_id = pp.payroll_id
991: AND ben_ext_person.g_effective_date BETWEEN pp.effective_start_date AND pp.effective_end_date
992: AND pp.soft_coding_keyflex_id = flex.soft_coding_keyflex_id