APPS.PAY_DK_ARCHIVE_EIN dependencies on PAY_BALANCE_DIMENSIONS

Line 33: FROM pay_balance_dimensions pbd,

29: AS
30: CURSOR csr_defined_balance_id
31: IS
32: SELECT pdb.defined_balance_id
33: FROM pay_balance_dimensions pbd,
34: pay_balance_types pbt,
35: pay_defined_balances pdb
36: WHERE pbd.database_item_suffix = p_dimension_suffix
37: AND pbd.business_group_id IS NULL

Line 71: ,pay_balance_dimensions pbd

67: CURSOR get_dbal_id(p_balance_name VARCHAR2 , p_balance_dim VARCHAR2) IS
68: SELECT pdb.defined_balance_id
69: FROM pay_defined_balances pdb
70: ,pay_balance_types pbt
71: ,pay_balance_dimensions pbd
72: WHERE pbt.legislation_code='DK'
73: AND pbt.balance_name = p_balance_name
74: AND pbd.legislation_code = 'DK'
75: AND pbd.database_item_suffix = p_balance_dim