APPS.PAY_MX_RULES dependencies on PAY_ELEMENT_TEMPLATES

Line 316: FROM pay_element_templates

312: INDEX BY BINARY_INTEGER;
313:
314: CURSOR c_tmplt_info ( cp_element_template_id NUMBER ) IS
315: SELECT *
316: FROM pay_element_templates
317: WHERE template_id = cp_element_template_id
318: AND template_type = 'U';
319:
320: CURSOR get_busgrp_info ( cp_business_group_id NUMBER ) IS

Line 356: l_tmplt pay_element_templates%ROWTYPE;

352: AND pscr.business_group_id IS NOT NULL
353: AND pscr.legislation_code IS NULL
354: AND pec.parent_classification_id IS NOT NULL;
355:
356: l_tmplt pay_element_templates%ROWTYPE;
357:
358: lv_legislation_code VARCHAR2(100);
359: lv_classification_name VARCHAR2(240);
360: lv_context VARCHAR2(240);