APPS.HR_AU_TAX_API dependencies on PAY_ELEMENT_TYPES_F

Line 148: FROM pay_element_types_f pet

144: l_mode VARCHAR2(100);
145:
146: CURSOR csr_paye_tax_element IS
147: SELECT pet.element_type_id
148: FROM pay_element_types_f pet
149: WHERE pet.element_name = 'Tax Information' -- Bug No: 3648796
150: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
151: AND legislation_code = 'AU';
152:

Line 789: FROM pay_element_types_f pet

785: l_tax_effective_date DATE;
786:
787: CURSOR csr_paye_tax_element IS
788: SELECT pet.element_type_id
789: FROM pay_element_types_f pet
790: WHERE pet.element_name = 'Superannuation Guarantee Information' -- Bug No: 3648796
791: AND l_session_date BETWEEN pet.effective_start_date AND pet.effective_end_date
792: AND legislation_code = 'AU';
793:

Line 835: FROM pay_element_types_f pet,

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

Line 1244: from pay_element_types_f pet

1240: cursor csr_paye_element
1241: (p_effective_date date
1242: ) is
1243: select pet.element_type_id
1244: from pay_element_types_f pet
1245: where pet.element_name = g_paye_element -- Bug No: 3648796
1246: and p_effective_date between pet.effective_start_date and pet.effective_end_date
1247: and legislation_code = g_legislation_code;
1248: --

Line 1623: from pay_element_types_f pet

1619: ,p_effective_date in date default null
1620: ) IS
1621: cursor csr_tax_element is
1622: select pet.element_type_id
1623: from pay_element_types_f pet
1624: where pet.element_name = g_paye_element
1625: and p_hire_date between pet.effective_start_date and pet.effective_end_date
1626: and legislation_code = g_legislation_code;
1627: --

Line 1644: (p_element_type_id pay_element_types_f.element_type_id%type

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

Line 1662: l_element_type_id pay_element_types_f.element_type_id%type;

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