APPS.PAY_NL_LSS_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 112: FROM PER_ALL_ASSIGNMENTS_F asg

108: is suspended for multiple times in the given pay_period. */
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

Line 250: per_all_assignments_f

246: AND pdb.balance_dimension_id = pbd.balance_dimension_id;
247:
248: CURSOR csr_min_date (assg_id number) IS
249: select min(effective_start_date) from
250: per_all_assignments_f
251: where assignment_id = assg_id;
252:
253: --Active Assignments
254: --

Line 259: FROM per_all_assignments_f

255: -- Assignments that are active as of 31st of the last year.
256: --
257: CURSOR csr_active_asg(l_date IN DATE) IS
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'

Line 267: AND NOT EXISTS (SELECT 1 from per_all_assignments_f

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
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'

Line 286: FROM per_all_assignments_f

282: CURSOR csr_term_asg(l_start_date IN DATE
283: ,l_end_date IN DATE) IS
284: SELECT effective_start_date - 1 term_dt
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'

Line 297: FROM per_all_assignments_f asg

293: AND payroll_id IS NOT NULL
294: UNION
295: SELECT effective_end_date ,
296: assignment_id
297: FROM per_all_assignments_f asg
298: WHERE person_id = p_person_id
299: AND effective_end_date BETWEEN l_start_date and l_end_date
300: AND payroll_id IS NOT NULL
301: AND NOT EXISTS( SELECT 1

Line 302: FROM per_all_assignments_f asg1

298: WHERE person_id = p_person_id
299: AND effective_end_date BETWEEN l_start_date and l_end_date
300: AND payroll_id IS NOT NULL
301: AND NOT EXISTS( SELECT 1
302: FROM per_all_assignments_f asg1
303: WHERE person_id = p_person_id
304: AND effective_start_date = asg.effective_end_date + 1
305: AND asg.assignment_id = asg1.assignment_id );
306:

Line 309: FROM per_all_assignments_f

305: AND asg.assignment_id = asg1.assignment_id );
306:
307: CURSOR csr_get_person IS
308: SELECT person_id
309: FROM per_all_assignments_f
310: WHERE assignment_id = p_assignment_id
311: AND business_group_id = p_business_group;
312:
313: CURSOR csr_cur_yr_col6 IS

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