APPS.PAY_US_PTO_CO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 415: per_all_assignments_f asg

411: cursor csr_get_assignment is
412: select distinct pee.assignment_id assignment_id, asg.assignment_number
413: from pay_element_entries_f pee,
414: pay_element_links_f pel,
415: per_all_assignments_f asg
416: where pee.element_type_id = p_plan_ele_type_id
417: and pee.element_type_id = pel.element_type_id
418: and pee.element_link_id = pel.element_link_id
419: and pee.assignment_id = asg.assignment_id

Line 430: per_all_assignments_f asg,

426: cursor csr_get_assignment is
427: select distinct pee.assignment_id assignment_id, asg.assignment_number
428: from pay_element_entries_f pee,
429: pay_element_links_f pel,
430: per_all_assignments_f asg,
431: per_periods_of_service pds
432: where pee.element_type_id = p_plan_ele_type_id
433: and pee.element_type_id = pel.element_type_id
434: and pee.element_link_id = pel.element_link_id

Line 639: from per_all_assignments_f asg

635: -- evaluated.
636: --
637: cursor c_get_asg_start_date is
638: select min(asg.effective_start_date)
639: from per_all_assignments_f asg
640: where asg.assignment_id = p_assignment_id
641: and asg.period_of_service_id is not null;
642:
643: --

Line 649: from per_all_assignments_f asg

645: -- so that terminated assignments can be evaluated.
646: --
647: cursor c_get_asg_end_date is
648: select max(asg.effective_end_date)
649: from per_all_assignments_f asg
650: where asg.assignment_id = p_assignment_id
651: and asg.period_of_service_id is not null;
652:
653: --

Line 661: from per_all_assignments_f asg

657: -- 'CURRENT', we also need to consider future assignments.
658: --
659: cursor c_payroll_id (p_effective_date date) is
660: select asg.payroll_id
661: from per_all_assignments_f asg
662: where asg.assignment_id = p_assignment_id
663: and asg.period_of_service_id is not null
664: and asg.payroll_id is not null
665: and ((p_effective_date between

Line 670: from per_all_assignments_f asg2

666: asg.effective_start_date and asg.effective_end_date)
667: or (asg.effective_end_date < p_effective_date
668: and asg.effective_end_date =
669: (select max(asg2.effective_end_date)
670: from per_all_assignments_f asg2
671: where asg2.assignment_id = asg.assignment_id
672: and asg2.period_of_service_id is not null
673: and asg2.payroll_id is not null))
674: or (p_accrual_term = 'CURRENT'

Line 678: from per_all_assignments_f asg3

674: or (p_accrual_term = 'CURRENT'
675: and asg.effective_start_date > p_effective_date
676: and asg.effective_start_date =
677: (select min(asg3.effective_start_date)
678: from per_all_assignments_f asg3
679: where asg3.assignment_id = asg.assignment_id
680: and asg3.period_of_service_id is not null
681: and asg3.payroll_id is not null)));
682: