eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on PER_ASSIGNMENTS_F

Line 2017: FROM per_assignments_f asg

2013: --Pick ptp value from Std conditions at asg level
2014: CURSOR csr_get_ptp_std_cond(c_assignment_id NUMBER,bg_id NUMBER) IS
2015: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc,
2016: asg.effective_start_date, asg.effective_end_date
2017: FROM per_assignments_f asg
2018: ,hr_soft_coding_keyflex scl
2019: WHERE asg.assignment_id = c_assignment_id
2020: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2021: AND asg.effective_start_date BETWEEN g_extract_params(bg_id).extract_start_date

Line 3929: FROM per_assignments_f asg

3925:
3926: --Pick ptp value from Std conditions at asg level
3927: CURSOR csr_get_ptp_asg_level(c_assignment_id NUMBER,c_effective_date IN DATE) IS
3928: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
3929: FROM per_assignments_f asg
3930: ,hr_soft_coding_keyflex target
3931: WHERE asg.assignment_id = c_assignment_id
3932: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3933: AND c_effective_date between asg.effective_start_date

Line 4926: FROM per_assignments_f asg

4922:
4923: --Pick ptp value from Std conditions at asg level
4924: CURSOR c_get_ptp_std_asg(c_effective_date IN DATE) IS
4925: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
4926: FROM per_assignments_f asg
4927: ,hr_soft_coding_keyflex target
4928: WHERE asg.assignment_id = p_assignment_id
4929: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
4930: AND c_effective_date between asg.effective_start_date