DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EHOL dependencies on PAY_BALANCE_DIMENSIONS

Line 69: FROM pay_balance_dimensions pbd,

65: AS
66: CURSOR csr_defined_balance_id
67: IS
68: SELECT pdb.defined_balance_id
69: FROM pay_balance_dimensions pbd,
70: pay_balance_types pbt,
71: pay_defined_balances pdb
72: WHERE pbd.database_item_suffix = p_dimension_suffix
73: AND pbd.business_group_id IS NULL

Line 107: ,pay_balance_dimensions pbd

103: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
104: SELECT pdb.defined_balance_id
105: FROM pay_defined_balances pdb
106: ,pay_balance_types pbt
107: ,pay_balance_dimensions pbd
108: WHERE pbt.legislation_code='DK'
109: AND pbt.balance_name = p_balance_name
110: AND pbd.legislation_code = 'DK'
111: AND pbd.database_item_suffix = p_balance_dim