APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 348: FROM pay_element_classifications pec,

344: AND core_object_type = 'ET';*/
345:
346: CURSOR get_sub_classifications (cp_element_type_id NUMBER) IS
347: SELECT pec.classification_name
348: FROM pay_element_classifications pec,
349: pay_sub_classification_rules pscr
350: WHERE pec.classification_id = pscr.classification_id
351: AND pscr.element_type_id = cp_element_type_id
352: AND pscr.business_group_id IS NOT NULL

Line 365: pay_element_classifications.classification_name%type;

361: ln_element_type_id NUMBER;
362:
363: l_element_type_extra_info_id NUMBER;
364: lv_sub_classification_name
365: pay_element_classifications.classification_name%type;
366: l_object_version_number NUMBER;
367: ln_rate_type_count NUMBER;
368: l_rate_type varchar_tab;
369: l_rate_desc varchar_tab;