DBA Data[Home] [Help]

APPS.PAY_KR_WG_REPORT_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 284: ,pay_balance_dimensions pbd

280: CURSOR csr_defined_bal_id
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

Line 354: ,pay_balance_dimensions pbd

350: IS
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