APPS.PAY_PL_UTILITY dependencies on PER_ALL_ASSIGNMENTS_F

Line 49: from per_all_assignments_f paaf1,

45: and p_date_earned between start_date and end_date;
46:
47: cursor csr_date_terminated is
48: select paaf1.effective_end_date,nvl(paaf1.payroll_id,-1)
49: from per_all_assignments_f paaf1,
50: per_assignment_status_types past1,
51: per_all_assignments_f paaf2,
52: per_assignment_status_types past2,
53: pay_all_payrolls_f papf,

Line 51: per_all_assignments_f paaf2,

47: cursor csr_date_terminated is
48: select paaf1.effective_end_date,nvl(paaf1.payroll_id,-1)
49: from per_all_assignments_f paaf1,
50: per_assignment_status_types past1,
51: per_all_assignments_f paaf2,
52: per_assignment_status_types past2,
53: pay_all_payrolls_f papf,
54: per_time_periods ptp
55: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 74: per_all_assignments_f paaf

70: cursor csr_contract_assgt_type(r_date date) is
71: select kyflx.segment3,past.per_system_status,paaf.person_id
72: from hr_soft_coding_keyflex kyflx,
73: per_assignment_status_types past,
74: per_all_assignments_f paaf
75: where paaf.assignment_id=p_assignment_id
76: and r_date between paaf.effective_start_date and paaf.effective_end_date
77: and paaf.soft_coding_keyflex_id=kyflx.soft_coding_keyflex_id
78: and paaf.assignment_status_type_id=past.assignment_status_type_id ;

Line 335: from per_all_assignments_f paaf1,

331: and p_date_earned between start_date and end_date;
332:
333: cursor csr_date_terminated is
334: select paaf1.effective_end_date terminated_date,nvl(paaf1.payroll_id,-1) payroll_id
335: from per_all_assignments_f paaf1,
336: per_assignment_status_types past1,
337: per_all_assignments_f paaf2,
338: per_assignment_status_types past2,
339: pay_all_payrolls_f papf,

Line 337: per_all_assignments_f paaf2,

333: cursor csr_date_terminated is
334: select paaf1.effective_end_date terminated_date,nvl(paaf1.payroll_id,-1) payroll_id
335: from per_all_assignments_f paaf1,
336: per_assignment_status_types past1,
337: per_all_assignments_f paaf2,
338: per_assignment_status_types past2,
339: pay_all_payrolls_f papf,
340: per_time_periods ptp
341: where past1.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')

Line 405: per_all_assignments_f paaf

401: cursor csr_contract_assgt_type(r_date date) is
402: select kyflx.segment3,kyflx.segment4,past.per_system_status,paaf.person_id
403: from hr_soft_coding_keyflex kyflx,
404: per_assignment_status_types past,
405: per_all_assignments_f paaf
406: where paaf.assignment_id=p_assignment_id
407: and r_date between paaf.effective_start_date and paaf.effective_end_date
408: and paaf.soft_coding_keyflex_id=kyflx.soft_coding_keyflex_id
409: and paaf.assignment_status_type_id=past.assignment_status_type_id ;

Line 413: from per_all_assignments_f paaf,hr_soft_coding_keyflex kyflex

409: and paaf.assignment_status_type_id=past.assignment_status_type_id ;
410:
411: cursor csr_normal_assignments(r_person_id number) is
412: select assignment_id
413: from per_all_assignments_f paaf,hr_soft_coding_keyflex kyflex
414: where paaf.person_id=r_person_id
415: and payroll_id= p_payroll_id
416: and kyflex.segment3='NORMAL'
417: and p_date_earned between paaf.effective_start_date and paaf.effective_end_date

Line 422: from per_all_assignments_f paaf

418: and kyflex.soft_coding_keyflex_id=paaf.soft_coding_keyflex_id;
419:
420: cursor csr_other_normal_contracts(r_person_id number) is
421: select 'Y'
422: from per_all_assignments_f paaf
423: ,hr_soft_coding_keyflex kyflex
424: ,per_assignment_status_types past
425: where paaf.person_id=r_person_id
426: and paaf.assignment_id<>p_assignment_id