DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYRS_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 435: pay_balance_dimensions dim,

431:
432: cursor csr_defined_bal_id is
433: select pdb.defined_balance_id
434: from pay_balance_types pbt,
435: pay_balance_dimensions dim,
436: pay_defined_balances pdb
437: where pbt.legislation_code = 'KR'
438: and pbt.balance_name = p_ytd_balance_name
439: and dim.legislation_code = 'KR'

Line 1460: ,pay_balance_dimensions pbd

1456: p_dimension_name in varchar2) is
1457: select defined_balance_id
1458: from pay_defined_balances pdb
1459: ,pay_balance_types pbt
1460: ,pay_balance_dimensions pbd
1461: where pbt.balance_type_id = pdb.balance_type_id
1462: and pdb.balance_dimension_id = pbd.balance_dimension_id
1463: and pbt.balance_name = p_balance_name
1464: and pbd.dimension_name = p_dimension_name