DBA Data[Home] [Help]

APPS.PAY_SE_TAX_DECL dependencies on PAY_BALANCE_TYPES

Line 147: ,pay_balance_types pbt

143: INTO
144: l_defined_balance_id
145: FROM
146: pay_defined_balances pdb
147: ,pay_balance_types pbt
148: ,pay_balance_dimensions pbd
149: WHERE
150: pbd.database_item_suffix = p_dbi_suffix
151: AND (pbd.legislation_code = 'SE' OR pbt.business_group_id = l_business_id)

Line 176: pay_balance_types pbt

172: SELECT
173: DISTINCT pbt.balance_name
174: INTO p_balance_name
175: FROM
176: pay_balance_types pbt
177: WHERE
178: pbt.input_value_id = p_input_value_id
179: AND ROWNUM < 2;
180: RETURN