APPS.PAY_NL_NSI_PROCESS dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 496: ,per_assignment_extra_info ee_si

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
500: and paa.assignment_status_type_id = asg_stat.assignment_status_type_id

Line 531: ,per_assignment_extra_info ee_si

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
535: AND paa.assignment_status_type_id = asg_stat.assignment_status_type_id

Line 564: ,per_assignment_extra_info ee_cadans

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
568: and scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 565: ,per_assignment_extra_info ee_si

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
568: and scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
569: and paa.assignment_status_type_id = asg_stat.assignment_status_type_id

Line 604: ,per_assignment_extra_info ee_cadans

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
608: AND scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

Line 605: ,per_assignment_extra_info ee_si

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
608: AND scl_flx.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
609: AND (lp_report_type = 'NL_CAD_NSI_ARCHIVE' OR lp_report_type='NL_CADZ_NSI_ARCHIVE' )

Line 819: FROM per_assignment_extra_info ee_gak

815: ,lp_process_date DATE) IS
816: SELECT
817: hr_general.decode_lookup('NL_GAK_OCCUPATION_DESCRIPTION',ee_gak.aei_information3) Occupation_Desc
818: ,ee_gak.aei_information4 Weekly_4_Exp_SI_Days
819: FROM per_assignment_extra_info ee_gak
820: WHERE ee_gak.assignment_id = lp_assignment_id
821: AND ee_gak.aei_information_category='NL_GAK_INFO'
822: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information1)
823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;

Line 836: FROM per_assignment_extra_info ee_cadans

832: ,ee_cadans.aei_information4 other_occupation_name
833: ,ee_cadans.aei_information5 collective_agreement_code
834: ,ee_cadans.aei_information6 insurance_abp
835: ,ee_cadans.aei_information7 risk_fund
836: FROM per_assignment_extra_info ee_cadans
837: WHERE ee_cadans.assignment_id = lp_assignment_id
838: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
839: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;