APPS.PAY_KW_ANNUAL_REPORTS dependencies on PER_PEOPLE_F

Line 114: ,per_people_f ppf

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
115: WHERE asg.assignment_id = paa.assignment_id
116: AND paa.payroll_action_id = ppa.payroll_action_id
117: AND ppa.action_type in ('R','Q')
118: AND ppa.action_status = 'C'

Line 151: FROM per_phones pp,per_people_f ppf

147:
148: /* Cursor for fetching person's phone details */
149: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
150: SELECT pp.phone_number
151: FROM per_phones pp,per_people_f ppf
152: WHERE pp.parent_id = ppf.person_id
153: AND pp.phone_type = l_ph_type
154: AND ppf.person_id = l_person_id
155: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line 173: FROM per_people_f ppf

169:
170: /* Cursor for fetching person's full name */
171: CURSOR csr_get_full_name (l_person_id number, l_effective_date date) IS
172: SELECT ppf.full_name
173: FROM per_people_f ppf
174: WHERE ppf.person_id = l_person_id
175: AND l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
176:
177: /* Cursor for fetching the person's assignment data */

Line 741: ,per_people_f ppf

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
742: WHERE asg.assignment_id = paa.assignment_id
743: AND paa.payroll_action_id = ppa.payroll_action_id
744: AND ppa.action_type in ('R','Q')
745: AND ppa.action_status = 'C'

Line 766: ,per_people_f ppf

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
767: WHERE asg.assignment_id = p_assignment_id
768: AND asg.assignment_id = paa.assignment_id
769: AND paa.payroll_action_id = ppa.payroll_action_id
770: AND ppa.action_type in ('R','Q')

Line 787: FROM per_people_f ppf

783: SELECT decode(l_format,'L',PER_INFORMATION3,SUBSTR(first_name,1,60)) first_name ,
784: decode(l_format,'L',PER_INFORMATION4,SUBSTR(PER_INFORMATION1,1,60)) father_name ,
785: decode(l_format,'L',PER_INFORMATION5,SUBSTR(PER_INFORMATION2,1,60)) grandfather_name,
786: decode(l_format,'L',PER_INFORMATION6,SUBSTR(last_name,1,60)) last_name
787: FROM per_people_f ppf
788: WHERE person_id = p_person_id
789: AND l_effective_date BETWEEN effective_start_date AND effective_end_date;
790: rec_get_emp_name csr_get_emp_name%ROWTYPE;
791:

Line 1403: ,per_people_f ppf

1399: ,pay_assignment_actions paa
1400: ,pay_payroll_actions ppa
1401: ,hr_soft_coding_keyflex hscl
1402: ,per_periods_of_service pos
1403: ,per_people_f ppf
1404: WHERE asg.assignment_id = paa.assignment_id
1405: AND paa.payroll_action_id = ppa.payroll_action_id
1406: AND pos.period_of_service_id = asg.period_of_service_id
1407: AND ppa.action_type in ('R','Q')

Line 1429: FROM per_people_f ppf , per_periods_of_service pos

1425: decode(l_format,'L',PER_INFORMATION4,per_information1),
1426: decode(l_format,'L',PER_INFORMATION5,per_information2),
1427: sex,date_of_birth, pos.date_start , national_identifier , per_information9,per_information10,
1428: fnd_date.canonical_to_date(per_information11)
1429: FROM per_people_f ppf , per_periods_of_service pos
1430: WHERE ppf.person_id = p_person_id
1431: AND ppf.person_id = pos.person_id
1432: AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1433: AND trunc(l_effective_date,'MM') between trunc(pos.date_start,'MM') and nvl(pos.actual_termination_date,to_date('31-12-4712','DD-MM-YYYY'));

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

Line 1637: FROM per_phones pp,per_people_f ppf

1633:
1634: /* cursor to fetch employee telephone details Oct 2012 */
1635: CURSOR csr_p_phone_data (l_person_id number,l_ph_type varchar2,l_effective_date date) IS
1636: SELECT pp.phone_number
1637: FROM per_phones pp,per_people_f ppf
1638: WHERE pp.parent_id = ppf.person_id
1639: AND pp.phone_type = l_ph_type
1640: AND ppf.person_id = l_person_id
1641: AND l_effective_date between pp.date_from and nvl(pp.date_to,to_date('31-12-4712','DD-MM-YYYY'));