DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_MTRA dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 440: from per_assignment_status_types

436: where assignment_id = p_asg_id
437: and paa.effective_start_date <= p_end_date
438: and paa.effective_end_date > = p_start_date
439: and assignment_status_type_id in (select assignment_status_type_id
440: from per_assignment_status_types
441: where per_system_status = 'ACTIVE_ASSIGN'
442: and active_flag = 'Y'
443: and ( (legislation_code is null and business_group_id is null)
444: or (business_group_id = p_business_group_id)