DBA Data[Home] [Help]

APPS.HR_AE_VALIDATE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1124: FROM per_all_assignments_f paaf,

1120: --
1121:
1122: CURSOR csr_fetch_bus_id IS
1123: SELECT distinct paaf.business_group_id
1124: FROM per_all_assignments_f paaf,
1125: hr_locations_all hl,
1126: hr_organization_information hoi
1127: WHERE paaf.location_id = p_location_id
1128: and paaf.location_id = hl.location_id

Line 1180: per_all_assignments_f asg

1176: DECLARE
1177: CURSOR csr_chk_qual IS
1178: SELECT qual.person_id
1179: FROM per_qualifications qual,
1180: per_all_assignments_f asg
1181: WHERE qual.person_id = asg.person_id
1182: AND qual.qualification_id = p_segment5
1183: AND asg.assignment_id = p_assignment_id;
1184: rec_chk_qual csr_chk_qual%ROWTYPE;