APPS.PAY_NL_LSS_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 113: ,PER_ASSIGNMENT_STATUS_TYPES past

109: CURSOR csr_asg_dates (p_other_assignment_id NUMBER) IS
110: SELECT asg.effective_start_date asg_start_date
111: ,asg.effective_end_date asg_end_date
112: FROM PER_ALL_ASSIGNMENTS_F asg
113: ,PER_ASSIGNMENT_STATUS_TYPES past
114: WHERE asg.assignment_id = p_other_assignment_id
115: AND past.per_system_status = 'ACTIVE_ASSIGN'
116: AND asg.assignment_status_type_id = past.assignment_status_type_id
117: -- AND asg.business_group_id = p_business_group

Line 262: FROM per_assignment_status_types

258: SELECT assignment_id
259: FROM per_all_assignments_f
260: WHERE person_id = p_person_id
261: AND assignment_status_type_id IN (SELECT assignment_status_type_id
262: FROM per_assignment_status_types
263: WHERE per_system_status = 'ACTIVE_ASSIGN'
264: AND active_flag = 'Y')
265: AND l_date BETWEEN effective_start_date and effective_end_date
266: AND payroll_id IS NOT NULL

Line 270: FROM per_assignment_status_types

266: AND payroll_id IS NOT NULL
267: AND NOT EXISTS (SELECT 1 from per_all_assignments_f
268: WHERE person_id = p_person_id
269: AND assignment_status_type_id IN (SELECT assignment_status_type_id
270: FROM per_assignment_status_types
271: WHERE per_system_status = 'TERM_ASSIGN'
272: AND active_flag = 'Y')
273: AND l_date BETWEEN effective_start_date and effective_end_date);
274:

Line 289: FROM per_assignment_status_types

285: ,assignment_id
286: FROM per_all_assignments_f
287: WHERE person_id = p_person_id
288: AND assignment_status_type_id IN (SELECT assignment_status_type_id
289: FROM per_assignment_status_types
290: WHERE per_system_status = 'TERM_ASSIGN'
291: AND active_flag = 'Y')
292: AND effective_start_date BETWEEN l_start_date and l_end_date
293: AND payroll_id IS NOT NULL

Line 602: select unique(assignment_id) from per_all_assignments_f paaf, PER_ASSIGNMENT_STATUS_TYPES past

598: l_assignment_exists number := 0; --0 means it doesnot exist, 1 means it exists
599: l_assignment_id_temp number;
600:
601: Cursor c_asg_exists_year(p_year NUMBER, p_assg_id NUMBER) IS
602: select unique(assignment_id) from per_all_assignments_f paaf, PER_ASSIGNMENT_STATUS_TYPES past
603: where paaf.assignment_id = p_assg_id
604: AND past.per_system_status = 'ACTIVE_ASSIGN'
605: AND paaf.assignment_status_type_id = past.assignment_status_type_id
606: and (to_char(effective_start_date,'YYYY') = p_year