DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYRS_PKG dependencies on PAY_DEFINED_BALANCES

Line 197: pay_defined_balances pdb

193: cursor csr_defined_bal_id is
194: select pdb.defined_balance_id
195: from pay_balance_types pbt,
196: pay_balance_dimensions dim,
197: pay_defined_balances pdb
198: where pbt.legislation_code = 'KR'
199: and pbt.balance_name = p_ytd_balance_name
200: and dim.legislation_code = 'KR'
201: and dim.dimension_name = '_ASG_YTD'

Line 760: from pay_defined_balances pdb

756:
757: cursor csr_get_ins_bal(p_balance_name in varchar2,
758: p_dimension_name in varchar2) is
759: select defined_balance_id
760: from pay_defined_balances pdb
761: ,pay_balance_types pbt
762: ,pay_balance_dimensions pbd
763: where pbt.balance_type_id = pdb.balance_type_id
764: and pdb.balance_dimension_id = pbd.balance_dimension_id