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 1837: -- added p_asg_set_id and usage of hr_assignment_sets (and _amendments) tables

1833: -- after transfer
1834: -- Select using less stringent criteria then validate the
1835: -- rows before archiving. Performance issue with functions in where clause.
1836: -- Add Ordered Index Hints for CBO issue.
1837: -- added p_asg_set_id and usage of hr_assignment_sets (and _amendments) tables
1838: SELECT /*+ ORDERED INDEX (asg PER_ASSIGNMENTS_F_N12,
1839: ppf PAY_PAYROLLS_F_PK,
1840: flex HR_SOFT_CODING_KEYFLEX_PK,
1841: org HR_ORGANIZATION_INFORMATIO_FK1,

Line 1886: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1

1882: AND per.person_id = asg.person_id
1883: AND p_end_date BETWEEN per.effective_start_date
1884: AND per.effective_end_date
1885: AND (p_asg_set_id IS NULL -- don't check for assignment set in this case
1886: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1
1887: WHERE has1.assignment_set_id = p_asg_set_id
1888: AND has1.business_group_id = asg.business_group_id
1889: AND nvl(has1.payroll_id, asg.payroll_id) = asg.payroll_id
1890: AND (NOT EXISTS (SELECT 1 -- chk no amendmts

Line 1971: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1

1967: AND per.person_id = pass.person_id
1968: AND p_end_date BETWEEN per.effective_start_date
1969: AND per.effective_end_date
1970: AND (p_asg_set_id IS NULL -- don't check for assignment set in this case
1971: OR EXISTS (SELECT 1 FROM hr_assignment_sets has1
1972: WHERE has1.assignment_set_id = p_asg_set_id
1973: AND has1.business_group_id = pass.business_group_id
1974: AND nvl(has1.payroll_id, pass.payroll_id) = pass.payroll_id
1975: AND (NOT EXISTS (SELECT 1 -- chk no amendmts