APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_ASSIGNMENT_SETS

Line 550: from hr_assignment_sets

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
550: from hr_assignment_sets
551: where assignment_set_id = p_asg_set_id;
552:
553: -- assuming that set can contains 1 type of Amendment
554: cursor csr_set_type(p_asg_set_id number) is

Line 606: from hr_assignment_sets has,

602: and pee.element_entry_id = peev.element_entry_id
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

Line 616: from hr_assignment_sets has,

612: and hasa.assignment_id = paa.assignment_id
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

Line 674: from hr_assignment_sets has,

670: and pee.element_entry_id = peev.element_entry_id
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