APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_LINKS_F

Line 875: pay_element_links_f pel,

871: pee.object_version_number,
872: pee.effective_start_date,
873: pee.effective_end_date
874: FROM pay_element_types_f pet,
875: pay_element_links_f pel,
876: pay_element_entries_f pee
877: WHERE pet.element_name = 'Tax Information'
878: AND pel.element_type_id = pet.element_type_id
879: AND pee.element_link_id = pel.element_link_id

Line 1687: ,p_payroll_id pay_element_links_f.payroll_id%type

1683: -- Checks if the element is linked to a payroll or linked to all payrolls
1684: --
1685: cursor csr_element_link
1686: (p_element_type_id pay_element_types_f.element_type_id%type
1687: ,p_payroll_id pay_element_links_f.payroll_id%type
1688: ,p_business_group_id pay_element_links_f.business_group_id%type
1689: ,p_hire_date date
1690: ) is
1691: select element_link_id

Line 1688: ,p_business_group_id pay_element_links_f.business_group_id%type

1684: --
1685: cursor csr_element_link
1686: (p_element_type_id pay_element_types_f.element_type_id%type
1687: ,p_payroll_id pay_element_links_f.payroll_id%type
1688: ,p_business_group_id pay_element_links_f.business_group_id%type
1689: ,p_hire_date date
1690: ) is
1691: select element_link_id
1692: , object_version_number

Line 1693: from pay_element_links_f

1689: ,p_hire_date date
1690: ) is
1691: select element_link_id
1692: , object_version_number
1693: from pay_element_links_f
1694: where element_type_id = p_element_type_id
1695: and business_group_id = p_business_group_id
1696: and (payroll_id = p_payroll_id or link_to_all_payrolls_flag is not null)
1697: and sysdate between effective_start_date and effective_end_date;

Line 1705: l_element_link_id pay_element_links_f.element_link_id%type;

1701: l_effective_start_date per_all_assignments_f.effective_start_date%type;
1702: l_effective_end_date per_all_assignments_f.effective_end_date%type;
1703: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1704: l_element_type_id pay_element_types_f.element_type_id%type;
1705: l_element_link_id pay_element_links_f.element_link_id%type;
1706: l_object_version_number per_all_assignments_f.object_version_number%type;
1707: l_create_warning boolean;
1708: l_update_warning boolean;
1709: l_cagr_grade_def_id number;