DBA Data[Home] [Help]

APPS.PAY_KR_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 289: from pay_balance_types pbt

285: p_bal_adj_source_text varchar2
286: )
287: is
288: select pbt.balance_type_id
289: from pay_balance_types pbt
290: where pbt.balance_type_id = p_balance_type_id
291: and nvl(p_run_type_id, nvl(p_bal_adj_run_type_id,-1))
292: = nvl(p_bal_adj_run_type_id,-1)
293: and nvl(p_source_text, nvl(p_bal_adj_source_text,'XX'))