APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 329: FROM pay_element_classifications pec,

325: AND core_object_type = 'ET';*/
326:
327: CURSOR get_sub_classifications (cp_element_type_id NUMBER) IS
328: SELECT pec.classification_name
329: FROM pay_element_classifications pec,
330: pay_sub_classification_rules pscr
331: WHERE pec.classification_id = pscr.classification_id
332: AND pscr.element_type_id = cp_element_type_id
333: AND pscr.business_group_id IS NOT NULL

Line 346: pay_element_classifications.classification_name%type;

342: ln_element_type_id NUMBER;
343:
344: l_element_type_extra_info_id NUMBER;
345: lv_sub_classification_name
346: pay_element_classifications.classification_name%type;
347: l_object_version_number NUMBER;
348: ln_rate_type_count NUMBER;
349: l_rate_type varchar_tab;
350: l_rate_desc varchar_tab;