APPS.PAY_SBC_BUS dependencies on PAY_SHADOW_BALANCE_TYPES

Line 95: , pay_shadow_balance_types bt

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
99: ;

Line 140: from pay_shadow_balance_types sbt

136: -- Cursor to check that the balance type exists.
137: --
138: cursor csr_balance_type_exists is
139: select null
140: from pay_shadow_balance_types sbt
141: where sbt.balance_type_id = p_balance_type_id;
142: --
143: l_proc varchar2(72) := g_package||'chk_balance_type_id';
144: l_exists varchar2(1);