DBA Data[Home] [Help]

APPS.PAY_SSR_BUS dependencies on PAY_TEMPLATE_EXCLUSION_RULES

Line 24: from pay_template_exclusion_rules ter

20: -- Cursor to check that the exclusion_rule_id is valid.
21: --
22: cursor csr_exclusion_rule_id_valid is
23: select null
24: from pay_template_exclusion_rules ter
25: , pay_shadow_element_types bt
26: where bt.element_type_id = p_element_type_id
27: and ter.exclusion_rule_id = p_exclusion_rule_id
28: and ter.template_id = bt.template_id