384: IS
385:
386: CURSOR csr_template IS
387: SELECT template_name
388: FROM pay_element_templates
389: WHERE template_id = p_template_id;
390:
391: l_template_name pay_element_templates.template_name%TYPE;
392:
387: SELECT template_name
388: FROM pay_element_templates
389: WHERE template_id = p_template_id;
390:
391: l_template_name pay_element_templates.template_name%TYPE;
392:
393: CURSOR csr_set IS
394: SELECT pet.element_type_id
395: ,pet.business_group_id
395: ,pet.business_group_id
396: ,pet.effective_start_date
397: ,pet.object_version_number
398: FROM pay_element_types_f pet
399: ,pay_element_templates tmp
400: WHERE pet.element_name = tmp.base_name
401: AND tmp.template_id = p_template_id;
402:
403: l_element_type_id pay_element_types.element_type_id%TYPE;