DBA Data[Home] [Help]

APPS.PAY_US_ELEM_ENT_CHK_LEG_HOOK dependencies on PAY_ELEMENT_TEMPLATES

Line 58: pay_element_templates pet

54: CURSOR c_get_template_id(cp_element_name varchar2,
55: cp_business_group_id number) IS
56: select pset.template_id
57: from pay_shadow_element_types pset,
58: pay_element_templates pet
59: where pet.template_id = pset.template_id
60: and pet.template_type = 'U'
61: and pset.element_name = cp_element_name
62: and pet.business_group_id = cp_business_group_id;