eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NL_NSI_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 493: per_all_assignments_f paa

489: ,null collective_agreement_code
490: ,null insurance_abp
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

Line 528: per_all_assignments_f paa

524: ,null collective_agreement_code
525: ,null insurance_abp
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

Line 561: per_all_assignments_f paa

557: ,ee_cadans.aei_information5 collective_agreement_code
558: ,ee_cadans.aei_information6 insurance_abp
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

Line 601: per_all_assignments_f paa

597: ,ee_cadans.aei_information5 collective_agreement_code
598: ,ee_cadans.aei_information6 insurance_abp
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

Line 694: from per_all_assignments_f asg,

690: --Select EE Assignment Effective Dates
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;

Line 710: from per_all_assignments_f asg,

706:
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;

Line 769: ,per_all_assignments_f paa

765: ,ee_info.Date_Of_Birth
766: ,ee_info.Employee_Number
767: ,paa.Assignment_Number
768: FROM per_all_people_f ee_info
769: ,per_all_assignments_f paa
770: WHERE ee_info.person_id = lp_person_id
771: AND ee_info.person_id = paa.person_id
772: AND paa.assignment_id = lp_assignment_id
773: AND lp_effective_date BETWEEN ee_info.Effective_Start_Date and ee_info.Effective_End_Date

Line 851: l_Person_ID per_all_assignments_f.person_id%TYPE;

847: l_ovn pay_action_information.object_version_number%TYPE;
848:
849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;
852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
855:

Line 852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;

848:
849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;
852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
855:
856: l_NSI_Process_Date varchar2(8);

Line 853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;

849: l_effective_date DATE;
850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;
852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
855:
856: l_NSI_Process_Date varchar2(8);
857: l_Hire_Date DATE;

Line 854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;

850: l_Employer_ID hr_organization_units.organization_id%TYPE;
851: l_Person_ID per_all_assignments_f.person_id%TYPE;
852: l_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
853: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
854: l_Prev_Assignment_ID per_all_assignments_f.assignment_id%TYPE;
855:
856: l_NSI_Process_Date varchar2(8);
857: l_Hire_Date DATE;
858: l_Asg_Effective_Start_Date DATE;

Line 1879: per_all_assignments_f paa

1875: ,scl_flx.SEGMENT2 Employment_Type
1876: ,scl_flx.SEGMENT3 Employment_SubType
1877: ,scl_flx.SEGMENT6 Work_Pattern
1878: FROM
1879: per_all_assignments_f paa
1880: ,per_all_people_f pap
1881: ,hr_soft_coding_keyflex scl_flx
1882: WHERE paa.business_group_id = lp_business_group_id
1883: and paa.person_id

Line 1979: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;

1975:
1976: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record
1977: v_Skip_Asg BOOLEAN;--Flag to control if processed asg can be skipped
1978: l_Withdraw_New_Hire BOOLEAN;--Flag returned by Withdraw Asg Proc if a Notif a=1 is withdrawn
1979: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
1980: l_Prev_Assignment_ID per_all_assignments_f.person_id%TYPE;
1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;
1982:
1983: l_effective_date DATE;

Line 1980: l_Prev_Assignment_ID per_all_assignments_f.person_id%TYPE;

1976: l_Create_NSI BOOLEAN;--Flag to Control Creation of NSI Record
1977: v_Skip_Asg BOOLEAN;--Flag to control if processed asg can be skipped
1978: l_Withdraw_New_Hire BOOLEAN;--Flag returned by Withdraw Asg Proc if a Notif a=1 is withdrawn
1979: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
1980: l_Prev_Assignment_ID per_all_assignments_f.person_id%TYPE;
1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;
1982:
1983: l_effective_date DATE;
1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;

Line 1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;

1977: v_Skip_Asg BOOLEAN;--Flag to control if processed asg can be skipped
1978: l_Withdraw_New_Hire BOOLEAN;--Flag returned by Withdraw Asg Proc if a Notif a=1 is withdrawn
1979: l_Prev_Person_ID per_all_assignments_f.person_id%TYPE;
1980: l_Prev_Assignment_ID per_all_assignments_f.person_id%TYPE;
1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;
1982:
1983: l_effective_date DATE;
1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;
1985: l_Person_ID per_all_assignments_f.person_id%TYPE;

Line 1985: l_Person_ID per_all_assignments_f.person_id%TYPE;

1981: l_Prev_SIProvider_ID per_all_assignments_f.person_id%TYPE;
1982:
1983: l_effective_date DATE;
1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;
1985: l_Person_ID per_all_assignments_f.person_id%TYPE;
1986: l_Assignment_ID per_all_assignments_f.person_id%TYPE;
1987: l_NSI_Process_Date DATE;
1988: l_Hire_Date DATE;
1989: l_Actual_Termination_Date DATE;

Line 1986: l_Assignment_ID per_all_assignments_f.person_id%TYPE;

1982:
1983: l_effective_date DATE;
1984: l_Registration_Number hr_organization_information.ORG_INFORMATION6%TYPE;
1985: l_Person_ID per_all_assignments_f.person_id%TYPE;
1986: l_Assignment_ID per_all_assignments_f.person_id%TYPE;
1987: l_NSI_Process_Date DATE;
1988: l_Hire_Date DATE;
1989: l_Actual_Termination_Date DATE;
1990: l_Assignment_Start_Date DATE;