APPS.PQP_NL_PGGM_FUNCTIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 1061: ,hr_soft_coding_keyflex target

1057: --
1058: CURSOR c_pt_cur (c_effective_date IN DATE) IS
1059: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
1060: FROM per_assignments_f asg
1061: ,hr_soft_coding_keyflex target
1062: WHERE asg.assignment_id = p_assignment_id
1063: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1064: AND trunc(c_effective_date) between asg.effective_start_date
1065: AND asg.effective_end_date

Line 1727: ,hr_soft_coding_keyflex target

1723: --
1724: CURSOR c_get_ptp(c_effective_date IN DATE) IS
1725: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
1726: FROM per_assignments_f asg
1727: ,hr_soft_coding_keyflex target
1728: WHERE asg.assignment_id = p_assignment_id
1729: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1730: AND c_effective_date between asg.effective_start_date
1731: AND asg.effective_end_date

Line 1748: ,hr_soft_coding_keyflex target

1744: ,asg.effective_start_date start_date
1745: ,asg.effective_end_date end_date
1746: FROM per_assignments_f asg
1747: ,per_assignment_status_types ast
1748: ,hr_soft_coding_keyflex target
1749: WHERE asg.assignment_id = p_assignment_id
1750: AND asg.assignment_status_type_id = ast.assignment_status_type_id
1751: AND ast.per_system_status = 'ACTIVE_ASSIGN'
1752: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 2026: ,hr_soft_coding_keyflex scl

2022: RETURN NUMBER IS
2023: CURSOR csr_get_inci_wkr_code(c_assignment_id NUMBER,c_date_earned DATE) IS
2024: SELECT scl.SEGMENT1
2025: FROM per_all_assignments_f asg
2026: ,hr_soft_coding_keyflex scl
2027: WHERE asg.assignment_id = c_assignment_id
2028: AND c_date_earned BETWEEN asg.effective_start_date
2029: AND asg.effective_end_date
2030: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;