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 2197: FROM per_people_f

2193:
2194: CURSOR c_person_id
2195: IS
2196: SELECT DISTINCT person_id
2197: FROM per_people_f
2198: WHERE per_information8 = p_pf_number
2199: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
2200:
2201: CURSOR c_termination_check(p_person_id NUMBER)

Line 2246: ,per_people_f pep

2242: IS
2243: SELECT 1 -- Modified for bug 4774108
2244: FROM per_assignments_f pea
2245: ,hr_soft_coding_keyflex hrscf
2246: ,per_people_f pep
2247: WHERE pea.person_id = pep.person_id
2248: AND pep.per_information8 = p_pf_number
2249: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
2250: AND pea.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id

Line 4219: ,per_people_f pep

4215: ,p_payroll_date DATE)
4216: IS
4217: SELECT 1
4218: FROM per_assignments_f pea--Modified for bug 4774108
4219: ,per_people_f pep
4220: ,hr_soft_coding_keyflex hrscf
4221: WHERE pea.person_id = pep.person_id
4222: AND pep.per_information9 = p_insurance_no
4223: AND pep.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

Line 4233: FROM per_people_f

4229:
4230: CURSOR c_person_id
4231: IS
4232: SELECT DISTINCT person_id
4233: FROM per_people_f
4234: WHERE per_information8 = p_insurance_no
4235: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
4236:
4237: CURSOR c_termination_check(p_person_id NUMBER

Line 4256: FROM per_people_f

4252: CURSOR c_death_date(p_start_date DATE
4253: ,p_end_date DATE)
4254: IS
4255: SELECT '1'
4256: FROM per_people_f
4257: WHERE person_id = (select distinct person_id
4258: from per_people_f
4259: where per_information9 = p_insurance_no
4260: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))

Line 4258: from per_people_f

4254: IS
4255: SELECT '1'
4256: FROM per_people_f
4257: WHERE person_id = (select distinct person_id
4258: from per_people_f
4259: where per_information9 = p_insurance_no
4260: and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'))
4261: AND date_of_death BETWEEN p_start_date AND p_end_date;
4262:

Line 4654: FROM per_people_f

4650:
4651: CURSOR c_person_id(p_insurance_no VARCHAR2)
4652: IS
4653: SELECT DISTINCT person_id
4654: FROM per_people_f
4655: WHERE per_information9 = p_insurance_no
4656: AND business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID');
4657: /*Bug 4282074*/
4658: CURSOR c_org_contr_days(p_esi_org_id VARCHAR2