DBA Data[Home] [Help]

APPS.PAY_US_LOC_CHANGE dependencies on PER_ALL_ASSIGNMENTS_F

Line 271: from per_all_assignments_f paf,

267: max(paf.effective_end_date) effective_end_date,
268: min(paf.effective_start_date) effective_start_date,
269: paf.business_group_id,
270: paf.assignment_type
271: from per_all_assignments_f paf,
272: hr_soft_coding_keyflex hsck
273: where (paf.location_id = p_loc_id
274: or hsck.segment18 = to_char(p_loc_id)) -- #3056158
275: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id

Line 288: from per_all_assignments_f paf,

284: select paf.location_id,
285: hsck.segment18,
286: paf.effective_start_date,
287: paf.effective_end_date
288: from per_all_assignments_f paf,
289: hr_soft_coding_keyflex hsck
290: where paf.assignment_id = p_assignment_id
291: and hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
292: and effective_start_date >= p_def_date