APPS.PAY_GB_EOY_ARCHIVE dependencies on HR_ASSIGNMENT_SETS

Line 14: g_asg_set_id hr_assignment_sets.assignment_set_id%type;

10: g_end_year DATE;
11: g_business_group_id hr_organization_units.business_group_id%TYPE;
12: g_permit_number VARCHAR2(12);
13: g_tax_district_reference VARCHAR2(3);
14: g_asg_set_id hr_assignment_sets.assignment_set_id%type;
15: g_context_id number;
16: g_tax_reference_number VARCHAR2(10); --4011263: length 10 chars
17: g_nia_able_id pay_defined_balances.defined_balance_id%TYPE;
18: g_nia_id pay_defined_balances.defined_balance_id%TYPE;

Line 1790: -- added p_asg_set_id and usage of hr_assignment_sets (and _amendments) tables

1786: -- after transfer
1787: -- Select using less stringent criteria then validate the
1788: -- rows before archiving. Performance issue with functions in where clause.
1789: -- Add Ordered Index Hints for CBO issue.
1790: -- added p_asg_set_id and usage of hr_assignment_sets (and _amendments) tables
1791: SELECT /*+ ORDERED INDEX (asg PER_ASSIGNMENTS_F_N12,
1792: ppf PAY_PAYROLLS_F_PK,
1793: flex HR_SOFT_CODING_KEYFLEX_PK,
1794: org HR_ORGANIZATION_INFORMATIO_FK1,

Line 1838: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1

1834: AND per.person_id = asg.person_id
1835: AND p_end_date BETWEEN per.effective_start_date
1836: AND per.effective_end_date
1837: AND (p_asg_set_id IS NULL -- don't check for assignment set in this case
1838: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1
1839: WHERE has1.assignment_set_id = p_asg_set_id
1840: AND has1.business_group_id = asg.business_group_id
1841: AND nvl(has1.payroll_id, asg.payroll_id) = asg.payroll_id
1842: AND (NOT EXISTS (SELECT 1 -- chk no amendmts

Line 1922: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1

1918: AND per.person_id = pass.person_id
1919: AND p_end_date BETWEEN per.effective_start_date
1920: AND per.effective_end_date
1921: AND (p_asg_set_id IS NULL -- don't check for assignment set in this case
1922: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1
1923: WHERE has1.assignment_set_id = p_asg_set_id
1924: AND has1.business_group_id = pass.business_group_id
1925: AND nvl(has1.payroll_id, pass.payroll_id) = pass.payroll_id
1926: AND (NOT EXISTS (SELECT 1 -- chk no amendmts