DBA Data[Home] [Help]

APPS.PQP_PRORATION_WRAPPER dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 39: FROM pay_element_type_extra_info

35: WHERE formula_name = UPPER(p_formula_name);
36:
37: CURSOR c_element_extra_info_cnt(p_ele_id IN NUMBER) IS
38: SELECT COUNT(*) count
39: FROM pay_element_type_extra_info
40: WHERE element_type_id = p_ele_id
41: AND information_type = 'PQP_UK_ELEMENT_ATTRIBUTION'
42: AND eei_information_category = 'PQP_UK_ELEMENT_ATTRIBUTION';
43:

Line 47: FROM pay_element_type_extra_info

43:
44: CURSOR c_element_extra_info_id(p_ele_id IN NUMBER) IS
45: SELECT element_type_extra_info_id,
46: object_version_number
47: FROM pay_element_type_extra_info
48: WHERE element_type_id = p_ele_id
49: AND information_type = 'PQP_UK_ELEMENT_ATTRIBUTION'
50: AND eei_information_category = 'PQP_UK_ELEMENT_ATTRIBUTION';
51: