APPS.PAY_US_PTO_CO_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 408: per_all_assignments_f asg

404: cursor csr_get_assignment is
405: select distinct pee.assignment_id assignment_id, asg.assignment_number
406: from pay_element_entries_f pee,
407: pay_element_links_f pel,
408: per_all_assignments_f asg
409: where pee.element_type_id = p_plan_ele_type_id
410: and pee.element_type_id = pel.element_type_id
411: and pee.element_link_id = pel.element_link_id
412: and pee.assignment_id = asg.assignment_id

Line 611: from per_all_assignments_f asg

607: -- evaluated.
608: --
609: cursor c_get_asg_start_date is
610: select min(asg.effective_start_date)
611: from per_all_assignments_f asg
612: where asg.assignment_id = p_assignment_id
613: and asg.period_of_service_id is not null;
614:
615: --

Line 621: from per_all_assignments_f asg

617: -- so that terminated assignments can be evaluated.
618: --
619: cursor c_get_asg_end_date is
620: select max(asg.effective_end_date)
621: from per_all_assignments_f asg
622: where asg.assignment_id = p_assignment_id
623: and asg.period_of_service_id is not null;
624:
625: --

Line 633: from per_all_assignments_f asg

629: -- 'CURRENT', we also need to consider future assignments.
630: --
631: cursor c_payroll_id (p_effective_date date) is
632: select asg.payroll_id
633: from per_all_assignments_f asg
634: where asg.assignment_id = p_assignment_id
635: and asg.period_of_service_id is not null
636: and asg.payroll_id is not null
637: and ((p_effective_date between

Line 642: from per_all_assignments_f asg2

638: asg.effective_start_date and asg.effective_end_date)
639: or (asg.effective_end_date < p_effective_date
640: and asg.effective_end_date =
641: (select max(asg2.effective_end_date)
642: from per_all_assignments_f asg2
643: where asg2.assignment_id = asg.assignment_id
644: and asg2.period_of_service_id is not null
645: and asg2.payroll_id is not null))
646: or (p_accrual_term = 'CURRENT'

Line 650: from per_all_assignments_f asg3

646: or (p_accrual_term = 'CURRENT'
647: and asg.effective_start_date > p_effective_date
648: and asg.effective_start_date =
649: (select min(asg3.effective_start_date)
650: from per_all_assignments_f asg3
651: where asg3.assignment_id = asg.assignment_id
652: and asg3.period_of_service_id is not null
653: and asg3.payroll_id is not null)));
654: