DBA Data[Home] [Help]

APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_DEFINED_BALANCES

Line 285: ,pay_defined_balances pdb

281: IS
282: SELECT pdb.defined_balance_id
283: from pay_balance_types pbt
284: ,pay_balance_dimensions pbd
285: ,pay_defined_balances pdb
286: where pbt.balance_name ='WG Deductions'
287: and pbt.legislation_code ='KR'
288: and pbd.database_item_suffix = p_dim_name
289: and pbd.legislation_code ='KR'

Line 355: ,pay_defined_balances pdb

351:
352: SELECT pdb.defined_balance_id
353: from pay_balance_types pbt
354: ,pay_balance_dimensions pbd
355: ,pay_defined_balances pdb
356: where pbt.balance_name ='WG Paid Interest'
357: and pbt.legislation_code ='KR'
358: and pbd.database_item_suffix = p_dim_name
359: and pbd.legislation_code ='KR'