APPS.PER_GB_TAX_BEN_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1395: FROM pay_element_types_f pet, pay_element_classifications pec

1391: IS
1392: CURSOR csr_p11d_elements (v_element_name VARCHAR2, v_leg_cd VARCHAR2)
1393: IS
1394: SELECT 1
1395: FROM pay_element_types_f pet, pay_element_classifications pec
1396: WHERE pet.classification_id = pec.classification_id
1397: AND pec.classification_name LIKE 'EXTERNAL REPORTING%'
1398: AND pet.legislation_code = v_leg_cd
1399: AND pet.element_name = v_element_name;

Line 1639: from pay_element_types_f pet

1635: -- BUG 3221422 Changed Query for improving performance
1636: CURSOR csr_el (v_el_type_id NUMBER, v_el_name VARCHAR2, v_leg_cd VARCHAR2)
1637: IS
1638: select pet.element_name, pet.element_type_id
1639: from pay_element_types_f pet
1640: where ( pet.element_type_id = v_el_type_id
1641: or pet.element_name = v_el_name
1642: )
1643: and pet.legislation_code = v_leg_cd

Line 1646: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1642: )
1643: and pet.legislation_code = v_leg_cd
1644: and pet.business_group_id is null;
1645: --
1646: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1647: l_element_name pay_element_types_f.element_name%TYPE;
1648: BEGIN
1649: hr_utility.set_location ( 'Entering:'
1650: || l_proc, 10);

Line 1647: l_element_name pay_element_types_f.element_name%TYPE;

1643: and pet.legislation_code = v_leg_cd
1644: and pet.business_group_id is null;
1645: --
1646: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1647: l_element_name pay_element_types_f.element_name%TYPE;
1648: BEGIN
1649: hr_utility.set_location ( 'Entering:'
1650: || l_proc, 10);
1651: OPEN csr_el (p_element_type_id, p_element_name, p_leg_cd);