APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_TYPES_F

Line 160: FROM pay_element_types_f pet

156: l_mode VARCHAR2(100);
157:
158: CURSOR csr_paye_tax_element IS
159: SELECT pet.element_type_id
160: FROM pay_element_types_f pet
161: WHERE pet.element_name = 'Tax Information' -- Bug No: 3648796
162: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
163: AND legislation_code = 'AU';
164:

Line 828: FROM pay_element_types_f pet

824: l_tax_effective_date DATE;
825:
826: CURSOR csr_paye_tax_element IS
827: SELECT pet.element_type_id
828: FROM pay_element_types_f pet
829: WHERE pet.element_name = 'Superannuation Guarantee Information' -- Bug No: 3648796
830: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
831: AND legislation_code = 'AU';
832:

Line 874: FROM pay_element_types_f pet,

870: SELECT pee.element_entry_id,
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

Line 1283: from pay_element_types_f pet

1279: cursor csr_paye_element
1280: (p_effective_date date
1281: ) is
1282: select pet.element_type_id
1283: from pay_element_types_f pet
1284: where pet.element_name = g_paye_element -- Bug No: 3648796
1285: and p_effective_date between pet.effective_start_date and pet.effective_end_date
1286: and legislation_code = g_legislation_code;
1287: --

Line 1665: from pay_element_types_f pet

1661: ,p_effective_date in date default null
1662: ) IS
1663: cursor csr_tax_element is
1664: select pet.element_type_id
1665: from pay_element_types_f pet
1666: where pet.element_name = g_paye_element
1667: and sysdate between pet.effective_start_date and pet.effective_end_date
1668: and legislation_code = g_legislation_code;
1669: --

Line 1686: (p_element_type_id pay_element_types_f.element_type_id%type

1682: -- Cursor to check the element links.
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

Line 1704: l_element_type_id pay_element_types_f.element_type_id%type;

1700: --
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;