DBA Data[Home] [Help]

APPS.PAY_IE_NES_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1330: pay_element_types_f pet

1326: CURSOR csr_input_value_id(p_element_name CHAR,
1327: p_value_name CHAR) IS
1328: SELECT piv.input_value_id
1329: FROM pay_input_values_f piv,
1330: pay_element_types_f pet
1331: WHERE piv.element_type_id = pet.element_type_id
1332: AND pet.legislation_code = 'IE'
1333: AND pet.element_name = p_element_name
1334: AND piv.name = p_value_name;