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 95: FROM per_assignments_f asg

91: CURSOR csr_get_emp (l_employer_id number, l_date date , l_nat varchar2) IS
92: SELECT distinct asg.person_id
93: ,asg.assignment_id
94: ,paa.assignment_action_id
95: FROM per_assignments_f asg
96: ,pay_assignment_actions paa
97: ,pay_payroll_actions ppa
98: ,hr_soft_coding_keyflex hscl
99: ,per_people_f ppf

Line 165: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

161:
162: /* Cursor for fetching the person's assignment data */
163: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
164: SELECT hsck.segment2,paf.job_id
165: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
166: WHERE paf.person_id = l_person_id
167: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
168: AND hsck.segment1 = p_employer_id
169: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 174: FROM per_assignments_f paf,per_jobs pjb

170:
171: /* Cursor for fetching the person's job */
172: CURSOR csr_p_job (l_person_id number,l_effective_date date) IS
173: SELECT pjb.name
174: FROM per_assignments_f paf,per_jobs pjb
175: WHERE paf.person_id = l_person_id
176: AND pjb.job_id = paf.job_id
177: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;
178:

Line 679: FROM per_assignments_f asg

675: SELECT distinct asg.person_id
676: ,asg.assignment_id
677: ,paa.assignment_action_id
678: ,ppa.date_earned
679: FROM per_assignments_f asg
680: ,pay_assignment_actions paa
681: ,pay_payroll_actions ppa
682: ,hr_soft_coding_keyflex hscl
683: ,per_people_f ppf

Line 704: FROM per_assignments_f asg

700: SELECT distinct asg.person_id
701: ,asg.assignment_id
702: ,paa.assignment_action_id
703: ,ppa.date_earned
704: FROM per_assignments_f asg
705: ,pay_assignment_actions paa
706: ,pay_payroll_actions ppa
707: ,hr_soft_coding_keyflex hscl
708: ,per_people_f ppf

Line 749: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

745:
746: /* Cursor for fetching the person's assignment data */
747: CURSOR csr_p_asg_data (l_person_id number,l_effective_date date) IS
748: SELECT hsck.segment2
749: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
750: WHERE paf.person_id = l_person_id
751: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
752: AND hsck.segment1 = p_employer_id
753: AND l_effective_date between paf.effective_start_date and paf.effective_end_date;

Line 758: FROM per_periods_of_service pos , per_assignments_f paf

754:
755: /* Cursor to fetch termination details */
756: CURSOR csr_get_term_details_56 (l_assignment_id number,l_date date) IS
757: SELECT pos.actual_termination_date,pos.leaving_reason
758: FROM per_periods_of_service pos , per_assignments_f paf
759: WHERE paf.assignment_id = l_assignment_id
760: AND paf.period_of_service_id = pos.period_of_service_id
761: AND trunc(pos.actual_termination_date,'MM') = trunc(l_date,'MM')
762: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date;

Line 775: from per_periods_of_service pos, per_assignments_f paf

771:
772: /* Cursor to fetch hire date for an employee */
773: CURSOR csr_get_hire_date_56(l_assignment_id number, l_date date) IS
774: SELECT pos.date_start
775: from per_periods_of_service pos, per_assignments_f paf
776: WHERE paf.assignment_id = l_assignment_id
777: AND paf.period_of_service_id = pos.period_of_service_id
778: AND trunc(pos.date_start,'MM') = trunc(l_date,'MM')
779: AND trunc(l_date,'MM') between trunc(paf.effective_start_date,'MM') and paf.effective_end_date;

Line 1340: FROM per_assignments_f asg

1336: ,asg.assignment_id
1337: ,paa.assignment_action_id
1338: ,ppa.date_earned
1339: ,decode(trunc(NVL(pos.actual_termination_date, to_date('31-12-4712','DD-MM-YYYY')),'MM'),TRUNC(l_date, 'MM'),'Y','N') term_flag
1340: FROM per_assignments_f asg
1341: ,pay_assignment_actions paa
1342: ,pay_payroll_actions ppa
1343: ,hr_soft_coding_keyflex hscl
1344: ,per_periods_of_service pos

Line 1380: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck

1376:
1377: /* Cursor for fetching the person's assignment data */
1378: CURSOR csr_p_asg_data (l_person_id number,l_date date) IS
1379: SELECT hsck.segment2,job_id , fnd_date.canonical_to_date(hsck.segment3)
1380: FROM per_assignments_f paf,hr_soft_coding_keyflex hsck
1381: WHERE paf.person_id = l_person_id
1382: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
1383: AND hsck.segment1 = p_employer_id
1384: AND l_date between paf.effective_start_date and paf.effective_end_date;

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

1540:
1541: /* Cursor to fetch person id and termination flag when Employee is the parameter */
1542: CURSOR csr_get_per_term_data (l_asg_id number , l_date date , l_nat varchar2) IS
1543: 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')
1544: FROM per_people_f ppf, per_periods_of_service pos , per_assignments_f paf
1545: WHERE paf.assignment_id = l_asg_id
1546: AND paf.person_id = ppf.person_id
1547: AND paf.period_of_service_id = pos.period_of_service_id
1548: AND paf.person_id = pos.person_id