APPS.PAY_SBA_BUS dependencies on PAY_SHADOW_DEFINED_BALANCES

Line 107: , pay_shadow_defined_balances db

103: cursor csr_exclusion_rule_id_valid is
104: select null
105: from pay_template_exclusion_rules ter
106: , pay_shadow_balance_types bt
107: , pay_shadow_defined_balances db
108: where db.defined_balance_id = p_defined_balance_id
109: and bt.balance_type_id = db.balance_type_id
110: and ter.exclusion_rule_id = p_exclusion_rule_id
111: and ter.template_id = bt.template_id

Line 153: from pay_shadow_defined_balances sdb

149: -- Cursor to check that the balance type exists.
150: --
151: cursor csr_defined_balance_exists is
152: select null
153: from pay_shadow_defined_balances sdb
154: where sdb.defined_balance_id = p_defined_balance_id;
155: --
156: l_proc varchar2(72) := g_package||'chk_defined_balance_id';
157: l_exists varchar2(1);