APPS.PAY_NL_ANNUAL_SI_FILE dependencies on PER_ALL_ASSIGNMENTS_F

Line 236: SELECT soft_coding_keyflex_id FROM per_all_assignments_f

232:
233: PROCEDURE get_si_special_indicator(p_assignment_id IN NUMBER,
234: l_si_special_indicator OUT NOCOPY VARCHAR2 )IS
235: CURSOR get_scl_id(p_assignment_id NUMBER) IS
236: SELECT soft_coding_keyflex_id FROM per_all_assignments_f
237: WHERE assignment_id = p_assignment_id AND
238: effective_start_date =
239: (SELECT max(effective_start_date)
240: FROM per_all_assignments_f asg,per_assignment_status_types past

Line 240: FROM per_all_assignments_f asg,per_assignment_status_types past

236: SELECT soft_coding_keyflex_id FROM per_all_assignments_f
237: WHERE assignment_id = p_assignment_id AND
238: effective_start_date =
239: (SELECT max(effective_start_date)
240: FROM per_all_assignments_f asg,per_assignment_status_types past
241: WHERE past.per_system_status = 'ACTIVE_ASSIGN'
242: AND asg.assignment_status_type_id = past.assignment_status_type_id and assignment_id = p_assignment_id);
243:
244: CURSOR get_si_special_indicator(p_scl_id NUMBER) IS

Line 641: ,per_all_assignments_f paa

637: pap.Date_of_Birth,
638: pap.national_identifier
639: from
640: per_all_people_f pap
641: ,per_all_assignments_f paa
642: ,hr_soft_coding_keyflex scl_flx
643: where
644: pap.business_group_id =p_business_group_id
645: and pap.person_id = paa.person_id

Line 652: FROM per_assignment_status_types past, per_all_assignments_f asg

648: and p_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
649: and paa.effective_start_date =
650: (
651: SELECT MIN(asg.effective_start_date)
652: FROM per_assignment_status_types past, per_all_assignments_f asg
653: WHERE asg.assignment_id = paa.assignment_id
654: and past.per_system_status = 'ACTIVE_ASSIGN'
655: and asg.assignment_status_type_id = past.assignment_status_type_id
656: and asg.effective_start_date <= p_Tax_Year_End_Date