DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PSTA dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1046: from per_assignment_status_types

1042: from per_all_assignments_f paaf, pay_assignment_actions paa
1043: where paaf.assignment_id = paa.assignment_id
1044: and paa.assignment_action_id = p_arch_assignment_action_id
1045: and assignment_status_type_id = (select assignment_status_type_id
1046: from per_assignment_status_types
1047: where per_system_status = 'TERM_ASSIGN'
1048: and active_flag = 'Y'
1049: and legislation_code is null
1050: and business_group_id is null)

Line 1064: from per_assignment_status_types

1060: where assignment_id = p_asg_id
1061: and paa.effective_start_date <= p_end_date
1062: and paa.effective_end_date > = p_start_date
1063: and assignment_status_type_id in (select assignment_status_type_id
1064: from per_assignment_status_types
1065: where per_system_status = 'ACTIVE_ASSIGN'
1066: and active_flag = 'Y'
1067: and ( (legislation_code is null and business_group_id is null)
1068: or (business_group_id = p_business_group_id)