APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 545: from hr_assignment_set_amendments

541: and fnd_date.canonical_to_date(l_benefit_end_date) between ppf.effective_start_date and ppf.effective_end_date; */
542:
543: cursor csr_check_asg_set(p_asg_set_id number) is
544: select count(*)
545: from hr_assignment_set_amendments
546: where assignment_set_id = p_asg_set_id;
547:
548: cursor csr_check_payroll(p_asg_set_id number) is
549: select payroll_id

Line 556: from hr_assignment_set_amendments

552:
553: -- assuming that set can contains 1 type of Amendment
554: cursor csr_set_type(p_asg_set_id number) is
555: select distinct include_or_exclude
556: from hr_assignment_set_amendments
557: where assignment_set_id = p_asg_set_id;
558: --bug 6278134 passed parameter to the csr_assign_set_X and csr_noassign_set
559:
560: cursor csr_assign_set_X is

Line 607: hr_assignment_set_amendments hasa

603: and peev.input_value_id = piv.input_value_id
604: and peev.screen_entry_value between l_benefit_start_date and l_benefit_end_date
605: and exists (select 1
606: from hr_assignment_sets has,
607: hr_assignment_set_amendments hasa
608: where has.assignment_set_id = l_assignment_set_id
609: and has.business_group_id = paa.business_group_id
610: and nvl(has.payroll_id, paa.payroll_id) = paa.payroll_id
611: and hasa.assignment_set_id = has.assignment_set_id

Line 617: hr_assignment_set_amendments hasa

613: and hasa.include_or_exclude = 'I')
614: --bug 6278134 removed exclude assignment set conditon
615: /*and not exists (select 1
616: from hr_assignment_sets has,
617: hr_assignment_set_amendments hasa
618: where has.assignment_set_id = l_assignment_set_id
619: and has.business_group_id = paa.business_group_id
620: and nvl(has.payroll_id, paa.payroll_id) = paa.payroll_id
621: and hasa.assignment_set_id = has.assignment_set_id

Line 675: hr_assignment_set_amendments hasa

671: and peev.input_value_id = piv.input_value_id
672: and peev.screen_entry_value between l_benefit_start_date and l_benefit_end_date
673: and not exists (select 1
674: from hr_assignment_sets has,
675: hr_assignment_set_amendments hasa
676: where has.assignment_set_id = l_assignment_set_id
677: and has.business_group_id = paa.business_group_id
678: and nvl(has.payroll_id, paa.payroll_id) = paa.payroll_id
679: and hasa.assignment_set_id = has.assignment_set_id