APPS.PAY_KR_BEE_UPLOAD dependencies on PAY_ELEMENT_TYPES_F

Line 1773: FROM pay_element_types_f pet

1769: CURSOR csr_el (v_el_type_id NUMBER, v_el_name VARCHAR2, v_leg_cd VARCHAR2)
1770: IS
1771: SELECT pet.element_name,
1772: pet.element_type_id
1773: FROM pay_element_types_f pet
1774: WHERE pet.element_type_id = v_el_type_id
1775: AND UPPER (pet.element_name) = UPPER (v_el_name)
1776: AND pet.legislation_code = v_leg_cd
1777: AND pet.business_group_id IS NULL;

Line 1786: FROM pay_element_types_f pet

1782: CURSOR csr_el_name (v_el_type_id NUMBER,v_leg_cd VARCHAR2)
1783: IS
1784: SELECT pet.element_name,
1785: pet.element_type_id
1786: FROM pay_element_types_f pet
1787: WHERE pet.element_type_id = v_el_type_id
1788: AND pet.legislation_code = v_leg_cd
1789: AND pet.business_group_id IS NULL;
1790:

Line 1795: FROM pay_element_types_f pet

1791: CURSOR csr_el_type_id (v_el_name VARCHAR2,v_leg_cd VARCHAR2)
1792: IS
1793: SELECT pet.element_name,
1794: pet.element_type_id
1795: FROM pay_element_types_f pet
1796: WHERE UPPER(pet.element_name) = UPPER(v_el_name)
1797: AND pet.legislation_code = v_leg_cd
1798: AND pet.business_group_id IS NULL;
1799:

Line 1802: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1798: AND pet.business_group_id IS NULL;
1799:
1800: -- End of Bug# 2485470
1801:
1802: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1803: l_element_name pay_element_types_f.element_name%TYPE;
1804: BEGIN
1805: hr_utility.set_location ( 'Entering:' || l_proc, 10);
1806: -- Added for Bug# 2485470

Line 1803: l_element_name pay_element_types_f.element_name%TYPE;

1799:
1800: -- End of Bug# 2485470
1801:
1802: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1803: l_element_name pay_element_types_f.element_name%TYPE;
1804: BEGIN
1805: hr_utility.set_location ( 'Entering:' || l_proc, 10);
1806: -- Added for Bug# 2485470
1807: -- Start of Bug# 2485470