DBA Data[Home] [Help]

APPS.PAY_ETM_BUS dependencies on PAY_ELEMENT_TEMPLATES

Line 164: from pay_element_templates pet

160: ,p_legislation_code in varchar2
161: ,p_business_group_id in number
162: ) is
163: select null
164: from pay_element_templates pet
165: where pet.template_type = 'T'
166: and upper(pet.template_name) = upper(p_template_name)
167: and
168: (

Line 485: from pay_element_templates pet

481: -- a business group.
482: --
483: cursor csr_base_name_exists is
484: select null
485: from pay_element_templates pet
486: where pet.template_type = 'U'
487: and upper(pet.base_name) = upper(p_base_name)
488: and pet.business_group_id = p_business_group_id;
489: --

Line 495: from pay_element_templates pet

491: -- within the scope of a business group.
492: --
493: cursor csr_name_exists_for_template is
494: select null
495: from pay_element_templates pet
496: where pet.template_type = 'U'
497: and upper(pet.base_name) = upper(p_base_name)
498: and pet.template_name = p_template_name
499: and pet.business_group_id = p_business_group_id;