DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_USER_INIT dependencies on PER_BUSINESS_GROUPS

Line 164: FROM per_business_groups

160: CURSOR get_busgrp_info ( cp_business_group_name varchar2 ) IS
161: SELECT business_group_id
162: ,legislation_code
163: ,currency_code
164: FROM per_business_groups
165: WHERE name = cp_business_group_name;
166:
167: CURSOR get_shd_ele_info ( cp_template_id NUMBER
168: ,cp_element_name VARCHAR2 ) IS

Line 851: per_business_groups pbg,

847: cursor cur_leg_code IS
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;