DBA Data[Home] [Help]

APPS.PAY_CN_ELEMENT_TEMPLATE_PKG dependencies on PAY_ELEMENT_TEMPLATES

Line 388: FROM pay_element_templates

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:

Line 391: l_template_name pay_element_templates.template_name%TYPE;

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

Line 399: ,pay_element_templates tmp

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;