APPS.PQP_US_SRS_EXTRACTS dependencies on PER_ASSIGNMENTS_F

Line 473: per_assignments_f asg

469: ,c_effective_date In Date) Is
470: Select to_number(sft.segment1),
471: asg.business_group_id
472: From hr_soft_coding_keyflex sft,
473: per_assignments_f asg
474: Where sft.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
475: And asg.assignment_id = c_assignment_id
476: And c_effective_date between asg.effective_start_date
477: and asg.effective_end_date;