APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 724: FROM per_assignments_f asg

720: CURSOR csr_get_asg_start_date(c_assignment_id IN NUMBER
721: ,c_period_start_date IN DATE
722: ,c_period_end_date IN DATE) IS
723: SELECT min (asg.effective_start_date)
724: FROM per_assignments_f asg
725: ,per_assignment_status_types past
726: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
727: AND past.per_system_status = 'ACTIVE_ASSIGN'
728: AND asg.effective_start_date <= trunc (c_period_end_date)

Line 744: FROM per_assignments_f asg

740: ,trunc (c_period_end_date)
741: ,asg.effective_end_date) end_date
742: ,fnd_number.canonical_to_number (nvl (target.segment29
743: ,'100')) ptp
744: FROM per_assignments_f asg
745: ,per_assignment_status_types past
746: ,hr_soft_coding_keyflex target
747: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
748: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 1200: FROM per_assignments_f asg

1196: asg.effective_start_date start_date
1197: ,asg.effective_end_date end_date
1198: ,least(fnd_number.canonical_to_number (nvl (target.segment29
1199: ,'100')),125) ptp
1200: FROM per_assignments_f asg
1201: ,hr_soft_coding_keyflex target
1202: WHERE asg.assignment_id = c_asg_id
1203: AND asg.effective_start_date BETWEEN c_start_date
1204: AND nvl (c_end_date

Line 1248: FROM per_assignments_f asg

1244: ,c_asg_id IN NUMBER) IS
1245: SELECT least (fnd_number.canonical_to_number (nvl (target.segment29
1246: ,'100'))
1247: ,125) ptp
1248: FROM per_assignments_f asg
1249: ,hr_soft_coding_keyflex target
1250: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1251: AND asg.assignment_id = c_asg_id
1252: AND target.enabled_flag = 'Y'

Line 1260: FROM per_assignments_f asg

1256: CURSOR csr_cur_sal_hour (c_effective_date IN DATE
1257: ,c_asg_id IN NUMBER) IS
1258: SELECT nvl (hourly_salaried_code
1259: ,'H') hourly_salaried_code
1260: FROM per_assignments_f asg
1261: ,hr_soft_coding_keyflex target
1262: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1263: AND asg.assignment_id = c_asg_id
1264: AND target.enabled_flag = 'Y'

Line 1294: l_hourly_salaried_code per_assignments_f.hourly_salaried_code%TYPE;

1290: ORDER BY start_date;
1291: --=========================================================================
1292: l_retro_pv_iv_id NUMBER;
1293: l_retro_ptp_element_id NUMBER;
1294: l_hourly_salaried_code per_assignments_f.hourly_salaried_code%TYPE;
1295: l_asg_hire_date DATE;
1296: l_asg_term_date DATE;
1297: l_ptp_chg_exist NUMBER;
1298: l_orig_dt_earned csr_get_orig_dt_earned%ROWTYPE;