APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_LINKS_F

Line 836: pay_element_links_f pel,

832: pee.object_version_number,
833: pee.effective_start_date,
834: pee.effective_end_date
835: FROM pay_element_types_f pet,
836: pay_element_links_f pel,
837: pay_element_entries_f pee
838: WHERE pet.element_name = 'Tax Information'
839: AND pel.element_type_id = pet.element_type_id
840: AND pee.element_link_id = pel.element_link_id

Line 1645: ,p_payroll_id pay_element_links_f.payroll_id%type

1641: -- Checks if the element is linked to a payroll or linked to all payrolls
1642: --
1643: cursor csr_element_link
1644: (p_element_type_id pay_element_types_f.element_type_id%type
1645: ,p_payroll_id pay_element_links_f.payroll_id%type
1646: ,p_business_group_id pay_element_links_f.business_group_id%type
1647: ,p_hire_date date
1648: ) is
1649: select element_link_id

Line 1646: ,p_business_group_id pay_element_links_f.business_group_id%type

1642: --
1643: cursor csr_element_link
1644: (p_element_type_id pay_element_types_f.element_type_id%type
1645: ,p_payroll_id pay_element_links_f.payroll_id%type
1646: ,p_business_group_id pay_element_links_f.business_group_id%type
1647: ,p_hire_date date
1648: ) is
1649: select element_link_id
1650: , object_version_number

Line 1651: from pay_element_links_f

1647: ,p_hire_date date
1648: ) is
1649: select element_link_id
1650: , object_version_number
1651: from pay_element_links_f
1652: where element_type_id = p_element_type_id
1653: and business_group_id = p_business_group_id
1654: and (payroll_id = p_payroll_id or link_to_all_payrolls_flag is not null)
1655: and p_hire_date between effective_start_date and effective_end_date;

Line 1663: l_element_link_id pay_element_links_f.element_link_id%type;

1659: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1660: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1661: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1662: l_element_type_id pay_element_types_f.element_type_id%type;
1663: l_element_link_id pay_element_links_f.element_link_id%type;
1664: l_object_version_number per_all_assignments_f.object_version_number%type;
1665: l_create_warning boolean;
1666: l_update_warning boolean;
1667: l_cagr_grade_def_id number;