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_PENSION_EXTRACTS dependencies on PER_ASSIGNMENTS_F

Line 663: FROM per_assignments_f asg

659: --
660: CURSOR c_cur_ptp (c_eff_dt IN DATE
661: ,c_asg_id IN NUMBER) IS
662: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
663: FROM per_assignments_f asg
664: ,hr_soft_coding_keyflex target
665: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
666: AND asg.assignment_id = c_asg_id
667: AND target.enabled_flag = 'Y'

Line 675: l_hourly_salaried_code per_assignments_f.hourly_salaried_code%type;

671: --7555712
672: --
673: -- Cursor to get the Salaried / Hourly Indicator
674: --
675: l_hourly_salaried_code per_assignments_f.hourly_salaried_code%type;
676:
677: CURSOR c_cur_sal_hour (c_eff_dt IN DATE
678: ,c_asg_id IN NUMBER) IS
679: SELECT nvl(hourly_salaried_code,'H') hourly_salaried_code

Line 680: FROM per_assignments_f asg

676:
677: CURSOR c_cur_sal_hour (c_eff_dt IN DATE
678: ,c_asg_id IN NUMBER) IS
679: SELECT nvl(hourly_salaried_code,'H') hourly_salaried_code
680: FROM per_assignments_f asg
681: ,hr_soft_coding_keyflex target
682: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
683: AND asg.assignment_id = c_asg_id
684: AND target.enabled_flag = 'Y'

Line 1037: FROM per_assignments_f asg

1033: CURSOR c_get_count_ptp_changes(c_asg_id in number
1034: ,c_period_start in date
1035: ,c_period_end in date) IS
1036: SELECT COUNT(*)
1037: FROM per_assignments_f asg
1038: ,per_assignment_status_types past
1039: ,hr_soft_coding_keyflex target
1040: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1041: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 1058: FROM per_assignments_f asg

1054: ,c_period_end in date) IS
1055: SELECT asg.effective_start_date Start_Date
1056: ,asg.effective_end_date End_Date
1057: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1058: FROM per_assignments_f asg
1059: ,per_assignment_status_types past
1060: ,hr_soft_coding_keyflex target
1061: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1062: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3599: FROM per_assignments_f asg

3595: CURSOR c_ude_rec05_ptp(p_asg_id number, p_start_date date, p_end_date date) IS
3596: SELECT DISTINCT asg.effective_start_date Start_Date
3597: ,asg.effective_end_date End_Date
3598: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))*100 ptp
3599: FROM per_assignments_f asg
3600: ,hr_soft_coding_keyflex target
3601: WHERE asg.assignment_id = p_asg_id
3602: AND asg.effective_start_date BETWEEN p_start_date AND nvl(p_end_date,to_date('31-12-4712','dd-mm-rrrr'))
3603: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 3641: FROM per_assignments_f asg

3637: CURSOR c_ret_rec05_ptp(p_asg_id number, p_start_date date, p_end_date date) IS
3638: SELECT DISTINCT asg.effective_start_date Start_Date
3639: ,asg.effective_end_date End_Date
3640: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))*100 ptp
3641: FROM per_assignments_f asg
3642: ,hr_soft_coding_keyflex target
3643: WHERE asg.assignment_id = p_asg_id
3644: AND asg.effective_start_date BETWEEN p_start_date AND nvl(p_end_date,to_date('31-12-4712','dd-mm-rrrr'))
3645: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id

Line 7834: FROM per_assignments_f asg,per_assignment_status_types past

7830: ) RETURN NUMBER IS
7831:
7832: CURSOR cur_get_asg_start_date(c_assign_id IN NUMBER) IS
7833: SELECT MIN(asg.effective_start_date)
7834: FROM per_assignments_f asg,per_assignment_status_types past
7835: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
7836: AND past.per_system_status = 'ACTIVE_ASSIGN'
7837: AND asg.assignment_id = c_assign_id;
7838:

Line 11056: FROM per_assignments_f asg

11052: CURSOR c_hire_ptp_chg (c_asg_id IN NUMBER) IS
11053: SELECT asg.effective_start_date Start_Date
11054: ,asg.effective_end_date End_Date
11055: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11056: FROM per_assignments_f asg
11057: ,hr_soft_coding_keyflex target
11058: ,per_assignment_status_types past
11059: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11060: AND asg.assignment_id = c_asg_id

Line 11205: FROM per_assignments_f asg

11201:
11202: CURSOR c_copos_ptp_chg (c_asg_id IN NUMBER
11203: ,c_eff_date IN DATE ) IS
11204: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11205: FROM per_assignments_f asg
11206: ,hr_soft_coding_keyflex target
11207: ,per_assignment_status_types past
11208: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11209: AND asg.assignment_id = c_asg_id