APPS.PAY_IN_REPORTS_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 2083: hr_soft_coding_keyflex scl,

2079: /*Cursor to get the employer classification details */
2080: CURSOR c_emplr_class is
2081: SELECT target.org_information3
2082: FROM per_assignments_f assign,
2083: hr_soft_coding_keyflex scl,
2084: hr_organization_information target
2085: WHERE assign.assignment_id = p_assignment_id
2086: AND p_earn_date BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date
2087: AND assign.soft_coding_keyflex_id = scl.soft_coding_keyflex_id

Line 2245: ,hr_soft_coding_keyflex hrscf

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

Line 4220: ,hr_soft_coding_keyflex hrscf

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

Line 4676: ,hr_soft_coding_keyflex scf

4672: FROM per_periods_of_service pps
4673: WHERE pps.period_of_service_id IN
4674: (SELECT asg.period_of_service_id
4675: FROM hr_organization_units hoi
4676: ,hr_soft_coding_keyflex scf
4677: ,per_all_assignments_f asg
4678: WHERE asg.person_id = p_person_id
4679: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
4680: AND hoi.organization_id = scf.segment4