DBA Data[Home] [Help]

APPS.PAY_SDB_BUS dependencies on PAY_TEMPLATE_EXCLUSION_RULES

Line 94: from pay_template_exclusion_rules ter

90: -- Cursor to check that the exclusion_rule_id is valid.
91: --
92: cursor csr_exclusion_rule_id_valid is
93: select null
94: from pay_template_exclusion_rules ter
95: , pay_shadow_balance_types bt
96: where bt.balance_type_id = p_balance_type_id
97: and ter.exclusion_rule_id = p_exclusion_rule_id
98: and ter.template_id = bt.template_id