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 1018: FROM per_assignments_f asg

1014: CURSOR c_get_count_ptp_changes(c_asg_id in number
1015: ,c_period_start in date
1016: ,c_period_end in date) IS
1017: SELECT COUNT(*)
1018: FROM per_assignments_f asg
1019: ,per_assignment_status_types past
1020: ,hr_soft_coding_keyflex target
1021: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1022: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 1039: FROM per_assignments_f asg

1035: ,c_period_end in date) IS
1036: SELECT asg.effective_start_date Start_Date
1037: ,asg.effective_end_date End_Date
1038: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1039: FROM per_assignments_f asg
1040: ,per_assignment_status_types past
1041: ,hr_soft_coding_keyflex target
1042: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1043: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 7495: FROM per_assignments_f asg,per_assignment_status_types past

7491: ) RETURN NUMBER IS
7492:
7493: CURSOR cur_get_asg_start_date(c_assign_id IN NUMBER) IS
7494: SELECT MIN(asg.effective_start_date)
7495: FROM per_assignments_f asg,per_assignment_status_types past
7496: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
7497: AND past.per_system_status = 'ACTIVE_ASSIGN'
7498: AND asg.assignment_id = c_assign_id;
7499:

Line 10717: FROM per_assignments_f asg

10713: CURSOR c_hire_ptp_chg (c_asg_id IN NUMBER) IS
10714: SELECT asg.effective_start_date Start_Date
10715: ,asg.effective_end_date End_Date
10716: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10717: FROM per_assignments_f asg
10718: ,hr_soft_coding_keyflex target
10719: ,per_assignment_status_types past
10720: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10721: AND asg.assignment_id = c_asg_id

Line 10866: FROM per_assignments_f asg

10862:
10863: CURSOR c_copos_ptp_chg (c_asg_id IN NUMBER
10864: ,c_eff_date IN DATE ) IS
10865: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10866: FROM per_assignments_f asg
10867: ,hr_soft_coding_keyflex target
10868: ,per_assignment_status_types past
10869: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10870: AND asg.assignment_id = c_asg_id