APPS.PAY_NL_ABP_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 526: FROM per_assignment_status_types

522: WHERE assignment_id = p_assignment_id
523: AND assignment_status_type_id IN
524: (
525: SELECT assignment_status_type_id
526: FROM per_assignment_status_types
527: WHERE per_system_status = 'TERM_ASSIGN'
528: AND active_flag = 'Y'
529: )
530: UNION

Line 557: FROM per_assignment_status_types

553: AND asg.assignment_id = asg1.assignment_id
554: AND asg1.assignment_status_type_id IN
555: (
556: SELECT assignment_status_type_id
557: FROM per_assignment_status_types
558: WHERE per_system_status = 'TERM_ASSIGN'
559: AND active_flag = 'Y'
560: )
561: );

Line 725: ,per_assignment_status_types past

721: ,c_period_start_date IN DATE
722: ,c_period_end_date IN DATE) IS
723: SELECT min (asg.effective_start_date)
724: FROM per_assignments_f asg
725: ,per_assignment_status_types past
726: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
727: AND past.per_system_status = 'ACTIVE_ASSIGN'
728: AND asg.effective_start_date <= trunc (c_period_end_date)
729: AND nvl (asg.effective_end_date

Line 745: ,per_assignment_status_types past

741: ,asg.effective_end_date) end_date
742: ,fnd_number.canonical_to_number (nvl (target.segment29
743: ,'100')) ptp
744: FROM per_assignments_f asg
745: ,per_assignment_status_types past
746: ,hr_soft_coding_keyflex target
747: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
748: AND past.per_system_status = 'ACTIVE_ASSIGN'
749: AND asg.effective_end_date >= c_effective_date

Line 1101: FROM per_assignment_status_types

1097: WHERE assignment_id = c_asg_id
1098: AND assignment_status_type_id IN
1099: (
1100: SELECT assignment_status_type_id
1101: FROM per_assignment_status_types
1102: WHERE per_system_status = 'ACTIVE_ASSIGN'
1103: AND active_flag = 'Y'
1104: )
1105: AND assignment_type = 'E';

Line 1114: FROM per_assignment_status_types

1110: WHERE assignment_id = c_asg_id
1111: AND assignment_status_type_id IN
1112: (
1113: SELECT assignment_status_type_id
1114: FROM per_assignment_status_types
1115: WHERE per_system_status = 'TERM_ASSIGN'
1116: AND active_flag = 'Y'
1117: )
1118: AND assignment_type = 'E';

Line 2457: FROM per_assignment_status_types

2453: AND asg.primary_flag = 'N'
2454: AND assignment_status_type_id IN
2455: (
2456: SELECT assignment_status_type_id
2457: FROM per_assignment_status_types
2458: WHERE per_system_status = 'TERM_ASSIGN'
2459: AND active_flag = 'Y'
2460: )
2461: GROUP BY period_of_service_id;

Line 3034: FROM per_assignment_status_types

3030: AND effective_start_date <= c_end_date
3031: AND assignment_status_type_id IN
3032: (
3033: SELECT assignment_status_type_id
3034: FROM per_assignment_status_types
3035: WHERE per_system_status = 'TERM_ASSIGN'
3036: AND active_flag = 'Y'
3037: )
3038: GROUP BY period_of_service_id

Line 3067: FROM per_assignment_status_types

3063: AND asg.assignment_id = asg1.assignment_id
3064: AND asg1.assignment_status_type_id IN
3065: (
3066: SELECT assignment_status_type_id
3067: FROM per_assignment_status_types
3068: WHERE per_system_status = 'TERM_ASSIGN'
3069: AND active_flag = 'Y'
3070: )
3071: )

Line 3085: FROM per_assignment_status_types ast

3081: AND paaf.person_id = p_person_id
3082: AND paaf.business_group_id = p_bg_id
3083: AND paaf.assignment_status_type_id in
3084: (SELECT ast.assignment_status_type_id
3085: FROM per_assignment_status_types ast
3086: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3087: );
3088: --15859347
3089: --=========================================================================