APPS.PAY_NL_NSI_PROCESS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 495: ,per_assignment_status_types asg_stat

491: ,null risk_fund
492: FROM
493: per_all_assignments_f paa
494: ,hr_soft_coding_keyflex scl_flx
495: ,per_assignment_status_types asg_stat
496: ,per_assignment_extra_info ee_si
497: WHERE paa.person_id = lp_person_id
498: and paa.assignment_id = lp_assignment_id
499: and scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 530: ,per_assignment_status_types asg_stat

526: ,null risk_fund
527: FROM
528: per_all_assignments_f paa
529: ,hr_soft_coding_keyflex scl_flx
530: ,per_assignment_status_types asg_stat
531: ,per_assignment_extra_info ee_si
532: WHERE paa.person_id = lp_person_id
533: AND paa.assignment_id = lp_assignment_id
534: AND scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 563: ,per_assignment_status_types asg_stat

559: ,ee_cadans.aei_information7 risk_fund
560: FROM
561: per_all_assignments_f paa
562: ,hr_soft_coding_keyflex scl_flx
563: ,per_assignment_status_types asg_stat
564: ,per_assignment_extra_info ee_cadans
565: ,per_assignment_extra_info ee_si
566: WHERE paa.person_id = lp_person_id
567: and paa.assignment_id = lp_assignment_id

Line 603: ,per_assignment_status_types asg_stat

599: ,ee_cadans.aei_information7 risk_fund
600: FROM
601: per_all_assignments_f paa
602: ,hr_soft_coding_keyflex scl_flx
603: ,per_assignment_status_types asg_stat
604: ,per_assignment_extra_info ee_cadans
605: ,per_assignment_extra_info ee_si
606: WHERE paa.person_id = lp_person_id
607: AND paa.assignment_id = lp_assignment_id

Line 695: per_assignment_status_types past

691: CURSOR csr_ee_asg_dates (lp_assignment_id NUMBER) IS
692: SELECT TO_CHAR(min(asg.effective_start_date),'DDMMYYYY') asg_start_date
693: ,TO_CHAR(max(asg.effective_end_date),'DDMMYYYY') asg_end_date
694: from per_all_assignments_f asg,
695: per_assignment_status_types past
696: where asg.assignment_id = lp_assignment_id
697: and past.per_system_status = 'ACTIVE_ASSIGN'
698: and asg.assignment_status_type_id = past.assignment_status_type_id;
699:

Line 711: per_assignment_status_types past

707: --Select EE Assignment Status
708: CURSOR csr_ee_asg_status (lp_assignment_id NUMBER,l_effective_date date) IS
709: SELECT asg.effective_start_date,asg.effective_end_date,past.per_system_status
710: from per_all_assignments_f asg,
711: per_assignment_status_types past
712: where asg.assignment_id = lp_assignment_id
713: and asg.assignment_status_type_id = past.assignment_status_type_id
714: and l_effective_date BETWEEN asg.effective_start_date and asg.effective_end_date;
715: v_csr_ee_asg_status csr_ee_asg_status%ROWTYPE;