APPS.PER_APPLICATIONS_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 964: , per_ass_status_type_amends b

960: --
961: CURSOR get_actve_apl IS
962: SELECT a.assignment_status_type_id
963: FROM per_assignment_status_types a
964: , per_ass_status_type_amends b
965: WHERE a.per_system_status = 'ACTIVE_APL'
966: AND b.assignment_status_type_id(+) = a.assignment_status_type_id
967: AND b.business_group_id(+) + 0 = p_business_group_id
968: AND nvl(a.business_group_id, p_business_group_id) =

Line 1066: , per_ass_status_type_amends b

1062: --
1063: CURSOR get_actve_apl IS
1064: SELECT a.assignment_status_type_id
1065: FROM per_assignment_status_types a
1066: , per_ass_status_type_amends b
1067: WHERE a.per_system_status = 'ACTIVE_APL'
1068: AND b.assignment_status_type_id(+) = a.assignment_status_type_id
1069: AND b.business_group_id(+) + 0 = p_business_group_id
1070: AND nvl(a.business_group_id, p_business_group_id) =

Line 2803: per_ass_status_type_amends b

2799: -- Reverse termination)
2800: cursor csr_get_asg_status is
2801: select a.assignment_status_type_id
2802: from per_assignment_status_types a,
2803: per_ass_status_type_amends b
2804: where a.per_system_status = l_ass_status
2805: and b.assignment_status_type_id(+) = a.assignment_status_type_id
2806: and b.business_group_id(+) + 0 = p_business_group_id
2807: and nvl(a.business_group_id, p_business_group_id) =