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_KW_ANNUAL_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 110: FROM per_assignments_f asg

106: CURSOR csr_get_emp (l_employer_id number, l_date date , l_nat varchar2) IS
107: SELECT distinct asg.person_id
108: ,asg.assignment_id
109: ,paa.assignment_action_id
110: FROM per_assignments_f asg
111: ,pay_assignment_actions paa
112: ,pay_payroll_actions ppa
113: ,hr_soft_coding_keyflex hscl
114: ,per_people_f ppf

Line 180: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

176:
177: /* Cursor for fetching the person's assignment data */
178: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
179: SELECT hsck.segment2,paf.job_id
180: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
181: WHERE paf.person_id = l_person_id
182: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
183: AND hsck.segment1 = p_employer_id
184: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 189: FROM per_assignments_f paf,per_jobs pjb

185:
186: /* Cursor for fetching the person's job */
187: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
188: SELECT pjb.name
189: FROM per_assignments_f paf,per_jobs pjb
190: WHERE paf.person_id = l_person_id
191: AND pjb.job_id = paf.job_id
192: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
193:

Line 737: FROM per_assignments_f asg

733: SELECT distinct asg.person_id
734: ,asg.assignment_id
735: ,paa.assignment_action_id
736: ,ppa.date_earned
737: FROM per_assignments_f asg
738: ,pay_assignment_actions paa
739: ,pay_payroll_actions ppa
740: ,hr_soft_coding_keyflex hscl
741: ,per_people_f ppf

Line 762: FROM per_assignments_f asg

758: SELECT distinct asg.person_id
759: ,asg.assignment_id
760: ,paa.assignment_action_id
761: ,ppa.date_earned
762: FROM per_assignments_f asg
763: ,pay_assignment_actions paa
764: ,pay_payroll_actions ppa
765: ,hr_soft_coding_keyflex hscl
766: ,per_people_f ppf

Line 807: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

803:
804: /* Cursor for fetching the person's assignment data */
805: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
806: SELECT hsck.segment2
807: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
808: WHERE paf.person_id = l_person_id
809: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
810: AND hsck.segment1 = p_employer_id
811: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 816: FROM per_periods_of_service pos , per_assignments_f paf

812:
813: /* Cursor to fetch termination details */
814: CURSOR csr_get_term_details_56 (l_assignment_id number,l_date date) IS
815: SELECT pos.actual_termination_date,pos.leaving_reason
816: FROM per_periods_of_service pos , per_assignments_f paf
817: WHERE paf.assignment_id = l_assignment_id
818: AND paf.period_of_service_id = pos.period_of_service_id
819: AND trunc(pos.actual_termination_date,'MM') = trunc(l_date,'MM')
820: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date;

Line 833: from per_periods_of_service pos, per_assignments_f paf

829:
830: /* Cursor to fetch hire date for an employee */
831: CURSOR csr_get_hire_date_56(l_assignment_id number, l_date date) IS
832: SELECT pos.date_start
833: from per_periods_of_service pos, per_assignments_f paf
834: WHERE paf.assignment_id = l_assignment_id
835: AND paf.period_of_service_id = pos.period_of_service_id
836: AND trunc(pos.date_start,'MM') = trunc(l_date,'MM')
837: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date;

Line 1398: FROM per_assignments_f asg

1394: ,asg.assignment_id
1395: ,paa.assignment_action_id
1396: ,ppa.date_earned
1397: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1398: FROM per_assignments_f asg
1399: ,pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,hr_soft_coding_keyflex hscl
1402: ,per_periods_of_service pos

Line 1438: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

1434:
1435: /* Cursor for fetching the person's assignment data */
1436: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1437: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1438: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1439: WHERE paf.person_id = l_person_id
1440: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1441: AND hsck.segment1 = p_employer_id
1442: AND l_date between paf.effective_start_date and paf.effective_end_date;

Line 1602: FROM per_people_f ppf, per_periods_of_service pos , per_assignments_f paf

1598:
1599: /* Cursor to fetch person id and termination flag when Employee is the parameter */
1600: CURSOR csr_get_per_term_data (l_asg_id number , l_date date , l_nat varchar2) IS
1601: SELECT ppf.person_id , paf.assignment_id , decode(trunc(pos.actual_termination_date,'MM'),trunc(l_date,'MM'),'Y','N') , decode(trunc(pos.date_start,'MM'),trunc(l_date,'MM'),'Y','N')
1602: FROM per_people_f ppf, per_periods_of_service pos , per_assignments_f paf
1603: WHERE paf.assignment_id = l_asg_id
1604: AND paf.person_id = ppf.person_id
1605: AND paf.period_of_service_id = pos.period_of_service_id
1606: AND paf.person_id = pos.person_id