APPS.PAY_IN_REPORTS_PKG dependencies on PER_PEOPLE_F

Line 46: FROM per_people_f pep -- Reduced cost from 2294 to 69

42: WHERE aei_information2 = LPAD(p_mon,2,'0')
43: AND aei_information1 = p_period
44: AND information_type = DECODE(p_report_type,'PF','PER_IN_PF_REMARKS','ESI','PER_IN_ESI_REMARKS')
45: AND assignment_id IN(SELECT DISTINCT pea.assignment_id
46: FROM per_people_f pep -- Reduced cost from 2294 to 69
47: ,per_assignments_f pea-- Done this for bug 4774018
48: WHERE pep.person_id = pea.person_id
49: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
50: AND p_number = DECODE(p_report_type,'PF'

Line 2778: FROM per_people_f

2774:
2775: CURSOR c_person_id
2776: IS
2777: SELECT DISTINCT person_id
2778: FROM per_people_f
2779: WHERE per_information8 = p_pf_number
2780: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
2781:
2782: CURSOR c_termination_check(p_person_id NUMBER)

Line 2827: ,per_people_f pep

2823: IS
2824: SELECT 1 -- Modified for bug 4774108
2825: FROM per_assignments_f pea
2826: ,hr_soft_coding_keyflex hrscf
2827: ,per_people_f pep
2828: WHERE pea.person_id = pep.person_id
2829: AND pep.per_information8 = p_pf_number
2830: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2831: AND pea.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id

Line 4938: ,per_people_f pep

4934: ,p_payroll_date DATE)
4935: IS
4936: SELECT 1
4937: FROM per_assignments_f pea--Modified for bug 4774108
4938: ,per_people_f pep
4939: ,hr_soft_coding_keyflex hrscf
4940: WHERE pea.person_id = pep.person_id
4941: AND pep.per_information9 = p_insurance_no
4942: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

Line 4952: FROM per_people_f

4948:
4949: CURSOR c_person_id
4950: IS
4951: SELECT DISTINCT person_id
4952: FROM per_people_f
4953: WHERE per_information8 = p_insurance_no
4954: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
4955:
4956: CURSOR c_termination_check(p_person_id NUMBER

Line 4975: FROM per_people_f

4971: CURSOR c_death_date(p_start_date DATE
4972: ,p_end_date DATE)
4973: IS
4974: SELECT '1'
4975: FROM per_people_f
4976: WHERE person_id = (select distinct person_id
4977: from per_people_f
4978: where per_information9 = p_insurance_no
4979: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))

Line 4977: from per_people_f

4973: IS
4974: SELECT '1'
4975: FROM per_people_f
4976: WHERE person_id = (select distinct person_id
4977: from per_people_f
4978: where per_information9 = p_insurance_no
4979: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))
4980: AND date_of_death BETWEEN p_start_date AND p_end_date;
4981:

Line 5373: FROM per_people_f

5369:
5370: CURSOR c_person_id(p_insurance_no VARCHAR2)
5371: IS
5372: SELECT DISTINCT person_id
5373: FROM per_people_f
5374: WHERE per_information9 = p_insurance_no
5375: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
5376: /*Bug 4282074*/
5377: CURSOR c_org_contr_days(p_esi_org_id VARCHAR2