DBA Data[Home] [Help]

APPS.PAY_BACKPAY_RULES_PKG dependencies on PAY_DEFINED_BALANCES

Line 124: pay_defined_balances db

120: from sys.dual
121: where not exists (
122: select null
123: from pay_backpay_rules br,
124: pay_defined_balances db
125: where br.backpay_set_id = P_BACKPAY_SET_ID
126: and br.defined_balance_id = db.defined_balance_id
127: and db.balance_type_id = P_BALANCE_TYPE_ID
128: and br.input_value_id = P_INPUT_VALUE_ID);

Line 175: pay_defined_balances db,

171: from sys.dual
172: where not exists (
173: select bf1.input_value_id, bf2.balance_type_id
174: from pay_backpay_rules br,
175: pay_defined_balances db,
176: pay_balance_feeds bf1,
177: pay_balance_feeds bf2
178: where bf1.balance_type_id = db.balance_type_id
179: and db.defined_balance_id = br.defined_balance_id