APPS.PAY_PL_PAYE_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 45: per_assignment_status_types past

41: cursor cur_asg is select nvl(assignment_eff_start_date,term_eff_start_date) effective_start_date from
42: (select min(paaf.effective_start_date) assignment_eff_start_date
43: from per_all_assignments_f paaf,
44: hr_soft_coding_keyflex scl,
45: per_assignment_status_types past
46: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
47: and paaf.SOFT_CODING_KEYFLEX_ID = scl.SOFT_CODING_KEYFLEX_ID
48: and paaf.assignment_id = p_per_or_asg_id
49: and paaf.business_group_id = p_business_group_id

Line 52: per_assignment_status_types past

48: and paaf.assignment_id = p_per_or_asg_id
49: and paaf.business_group_id = p_business_group_id
50: and past.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN') and not exists ( select
51: paaf.effective_start_date from per_all_assignments_f paaf,
52: per_assignment_status_types past
53: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
54: and past.per_system_status = 'TERM_ASSIGN'
55: and paaf.assignment_id = p_per_or_asg_id
56: and paaf.business_group_id = p_business_group_id

Line 59: per_assignment_status_types past

55: and paaf.assignment_id = p_per_or_asg_id
56: and paaf.business_group_id = p_business_group_id
57: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date)),
58: (select min(paaf.effective_start_date) term_eff_start_date from per_all_assignments_f paaf,
59: per_assignment_status_types past
60: where paaf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID
61: and past.per_system_status = 'TERM_ASSIGN'
62: and paaf.assignment_id = p_per_or_asg_id
63: and paaf.business_group_id = p_business_group_id