APPS.PQP_NL_ABP_FUNCTIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 5003: ,hr_soft_coding_keyflex target

4999: CURSOR c_cur_ptp (c_eff_dt IN DATE
5000: ,c_asg_id IN NUMBER) IS
5001: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
5002: FROM per_assignments_f asg
5003: ,hr_soft_coding_keyflex target
5004: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
5005: AND asg.assignment_id = c_asg_id
5006: AND target.enabled_flag = 'Y'
5007: AND TRUNC(c_eff_dt) BETWEEN asg.effective_start_date AND

Line 6670: FROM hr_soft_coding_keyflex

6666: -- Cursor to get the part time perc from the SC KFF
6667: --
6668: CURSOR c_ptp (c_kff_id IN NUMBER) IS
6669: SELECT fnd_number.canonical_to_number(segment29)
6670: FROM hr_soft_coding_keyflex
6671: WHERE soft_coding_keyflex_id = c_kff_id;
6672:
6673: CURSOR c_log_xst( c_kff_id IN NUMBER
6674: ,c_st_dt IN ben_ext_chg_evt_log.prmtr_04%TYPE

Line 7139: ,hr_soft_coding_keyflex target

7135: CURSOR c_cur_ptp (c_eff_dt IN DATE
7136: ,c_asg_id IN NUMBER) IS
7137: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
7138: FROM per_assignments_f asg
7139: ,hr_soft_coding_keyflex target
7140: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
7141: AND asg.assignment_id = c_asg_id
7142: AND target.enabled_flag = 'Y'
7143: AND trunc(c_eff_dt) BETWEEN asg.effective_start_date AND