APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_TEMPLATES

Line 297: FROM pay_element_templates

293: INDEX BY BINARY_INTEGER;
294:
295: CURSOR c_tmplt_info ( cp_element_template_id NUMBER ) IS
296: SELECT *
297: FROM pay_element_templates
298: WHERE template_id = cp_element_template_id
299: AND template_type = 'U';
300:
301: CURSOR get_busgrp_info ( cp_business_group_id NUMBER ) IS

Line 337: l_tmplt pay_element_templates%ROWTYPE;

333: AND pscr.business_group_id IS NOT NULL
334: AND pscr.legislation_code IS NULL
335: AND pec.parent_classification_id IS NOT NULL;
336:
337: l_tmplt pay_element_templates%ROWTYPE;
338:
339: lv_legislation_code VARCHAR2(100);
340: lv_classification_name VARCHAR2(240);
341: lv_context VARCHAR2(240);