DBA Data[Home] [Help]

APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 2075: hr_soft_coding_keyflex sck

2071: p_gre_type VARCHAR2) IS
2072: SELECT asg.assignment_id,
2073: asg.business_group_id
2074: FROM per_all_assignments_f asg,
2075: hr_soft_coding_keyflex sck
2076: WHERE decode(p_gre_type, 'T4A/RL1', sck.segment11, 'T4A/RL2', sck.segment12,
2077: sck.segment1) = TO_CHAR(p_gre)
2078: AND asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
2079: AND EXISTS(SELECT 'X'

Line 2623: from hr_soft_coding_keyflex sck

2619: and prb.assignment_id = asg.assignment_id
2620: and prb.effective_date between asg.effective_start_date
2621: AND asg.effective_end_date
2622: and exists (select 1
2623: from hr_soft_coding_keyflex sck
2624: where asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
2625: AND decode(p_gre_type, 'T4A/RL1', sck.segment11,
2626: 'T4A/RL2', sck.segment12,
2627: sck.segment1) = TO_CHAR(p_gre))