APPS.PQP_NL_PGGM_FUNCTIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1215: ,hr_soft_coding_keyflex target

1211: --
1212: CURSOR c_pt_cur (c_effective_date IN DATE) IS
1213: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
1214: FROM per_assignments_f asg
1215: ,hr_soft_coding_keyflex target
1216: WHERE asg.assignment_id = p_assignment_id
1217: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1218: AND trunc(c_effective_date) between asg.effective_start_date
1219: AND asg.effective_end_date

Line 1881: ,hr_soft_coding_keyflex target

1877: --
1878: CURSOR c_get_ptp(c_effective_date IN DATE) IS
1879: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
1880: FROM per_assignments_f asg
1881: ,hr_soft_coding_keyflex target
1882: WHERE asg.assignment_id = p_assignment_id
1883: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1884: AND c_effective_date between asg.effective_start_date
1885: AND asg.effective_end_date

Line 1902: ,hr_soft_coding_keyflex target

1898: ,asg.effective_start_date start_date
1899: ,asg.effective_end_date end_date
1900: FROM per_assignments_f asg
1901: ,per_assignment_status_types ast
1902: ,hr_soft_coding_keyflex target
1903: WHERE asg.assignment_id = p_assignment_id
1904: AND asg.assignment_status_type_id = ast.assignment_status_type_id
1905: AND ast.per_system_status = 'ACTIVE_ASSIGN'
1906: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 2180: ,hr_soft_coding_keyflex scl

2176: RETURN NUMBER IS
2177: CURSOR csr_get_inci_wkr_code(c_assignment_id NUMBER,c_date_earned DATE) IS
2178: SELECT scl.SEGMENT1
2179: FROM per_all_assignments_f asg
2180: ,hr_soft_coding_keyflex scl
2181: WHERE asg.assignment_id = c_assignment_id
2182: AND c_date_earned BETWEEN asg.effective_start_date
2183: AND asg.effective_end_date
2184: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;