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 HR_SOFT_CODING_KEYFLEX

Line 2018: ,hr_soft_coding_keyflex scl

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
2022: AND g_extract_params(p_business_group_id).extract_end_date;

Line 2028: ,hr_soft_coding_keyflex scl

2024: --Cursor to check the previous PTP in the Std Conditions tab
2025: CURSOR csr_get_prev_ptp_std_cond(c_asg_id NUMBER,c_date DATE) IS
2026: SELECT fnd_number.canonical_to_number(NVL(scl.SEGMENT29,'0')) pt_perc
2027: FROM per_all_assignments_f asg
2028: ,hr_soft_coding_keyflex scl
2029: WHERE asg.assignment_id = c_asg_id
2030: AND (c_date - 1 BETWEEN asg.effective_start_date
2031: AND asg.effective_end_date)
2032: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 2083: ,hr_soft_coding_keyflex scl

2079: -------Cursor to check whether there is any change in incidental worker code
2080: CURSOR csr_chk_inci_code_ele(c_asg_id NUMBER,bg_id NUMBER) IS
2081: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1, asg.effective_start_date,asg.effective_end_date
2082: FROM per_all_assignments_f asg
2083: ,hr_soft_coding_keyflex scl
2084: WHERE asg.assignment_id = c_asg_id
2085: AND (asg.effective_start_date BETWEEN g_extract_params(bg_id).extract_start_date
2086: AND g_extract_params(p_business_group_id).extract_end_date)
2087: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 2208: ,hr_soft_coding_keyflex scl

2204: -------Cursor to check whether there is any change in incidental worker code
2205: CURSOR csr_chk_inci_code_chg_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
2206: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1
2207: FROM per_all_assignments_f asg
2208: ,hr_soft_coding_keyflex scl
2209: WHERE asg.assignment_id = c_asg_id
2210: AND (c_date - 1 BETWEEN asg.effective_start_date
2211: AND asg.effective_end_date)
2212: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 3217: ,hr_soft_coding_keyflex scl

3213: --from the soft coding key flex
3214: CURSOR c_get_emp_code IS
3215: SELECT scl.SEGMENT2||scl.SEGMENT3
3216: FROM per_all_assignments_f asg
3217: ,hr_soft_coding_keyflex scl
3218: WHERE asg.assignment_id = p_assignment_id
3219: AND p_effective_date BETWEEN asg.effective_start_date
3220: AND asg.effective_end_date
3221: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 3930: ,hr_soft_coding_keyflex target

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
3934: AND asg.effective_end_date

Line 3992: ,hr_soft_coding_keyflex scl

3988:
3989: CURSOR csr_get_incidental_wkr_code(c_asg_id Number ,c_date_earned Date) IS
3990: SELECT Decode(scl.SEGMENT1,'Y','0','1')
3991: FROM per_all_assignments_f asg
3992: ,hr_soft_coding_keyflex scl
3993: WHERE asg.assignment_id = c_asg_id
3994: AND c_date_earned BETWEEN asg.effective_start_date
3995: AND asg.effective_end_date
3996: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 4927: ,hr_soft_coding_keyflex target

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
4931: AND asg.effective_end_date

Line 5058: ,hr_soft_coding_keyflex scl

5054: Return Number IS
5055: CURSOR csr_get_incidental_wkr_code(c_asg_id Number ,c_date_earned Date) IS
5056: SELECT Decode(scl.SEGMENT1,'Y','0','1')
5057: FROM per_all_assignments_f asg
5058: ,hr_soft_coding_keyflex scl
5059: WHERE asg.assignment_id = c_asg_id
5060: AND c_date_earned BETWEEN asg.effective_start_date
5061: AND asg.effective_end_date
5062: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;

Line 5712: ,hr_soft_coding_keyflex scl

5708: -------Cursor to check whether there is any change in incidental worker code
5709: CURSOR csr_chk_inci_code_chg_ele(c_asg_id NUMBER,bg_id NUMBER,c_date DATE) IS
5710: SELECT Decode(scl.SEGMENT1,'Y','0','1') segment1
5711: FROM per_all_assignments_f asg
5712: ,hr_soft_coding_keyflex scl
5713: WHERE asg.assignment_id = c_asg_id
5714: AND (c_date - 1 BETWEEN asg.effective_start_date
5715: AND asg.effective_end_date)
5716: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;