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