APPS.PAY_IN_REPORTS_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 2664: hr_soft_coding_keyflex scl,

2660: /*Cursor to get the employer classification details */
2661: CURSOR c_emplr_class is
2662: SELECT target.org_information3
2663: FROM per_assignments_f assign,
2664: hr_soft_coding_keyflex scl,
2665: hr_organization_information target
2666: WHERE assign.assignment_id = p_assignment_id
2667: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2668: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 2826: ,hr_soft_coding_keyflex hrscf

2822: ,p_payroll_date DATE)
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')

Line 4939: ,hr_soft_coding_keyflex hrscf

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')
4943: AND pea.soft_coding_keyflex_id=hrscf.soft_coding_keyflex_id

Line 5395: ,hr_soft_coding_keyflex scf

5391: FROM per_periods_of_service pps
5392: WHERE pps.period_of_service_id IN
5393: (SELECT asg.period_of_service_id
5394: FROM hr_organization_units hoi
5395: ,hr_soft_coding_keyflex scf
5396: ,per_all_assignments_f asg
5397: WHERE asg.person_id = p_person_id
5398: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
5399: AND hoi.organization_id = scf.segment4