DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PAY_ELEMENT_TEMPLATES

Line 156: FROM pay_element_templates

152:
153: CURSOR get_template_id ( cp_legislation_code varchar2
154: ,cp_template_name varchar2) IS
155: SELECT template_id
156: FROM pay_element_templates
157: WHERE legislation_code = cp_legislation_code
158: AND template_name = cp_template_name;
159:
160: CURSOR get_busgrp_info ( cp_business_group_name varchar2 ) IS

Line 852: pay_element_templates pet

848: SELECT
849: pbg.legislation_code
850: FROM
851: per_business_groups pbg,
852: pay_element_templates pet
853: WHERE
854: pet.template_id = p_template_id AND
855: pet.business_group_id = pbg.business_group_id;
856: