DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on PAY_BALANCE_DIMENSIONS

Line 287: ,c_dimension_name pay_balance_dimensions.database_item_suffix%type) is

283: l_supp_pymt_date DATE;
284:
285:
286: cursor cur_defined_balance_id (c_balance_name pay_balance_types.balance_name%type
287: ,c_dimension_name pay_balance_dimensions.database_item_suffix%type) is
288: select pdb.defined_balance_id
289:
290: from pay_defined_balances pdb
291: ,pay_balance_dimensions pbd

Line 291: ,pay_balance_dimensions pbd

287: ,c_dimension_name pay_balance_dimensions.database_item_suffix%type) is
288: select pdb.defined_balance_id
289:
290: from pay_defined_balances pdb
291: ,pay_balance_dimensions pbd
292: ,pay_balance_types pbt
293:
294: WHERE pbt.balance_name=c_balance_name
295: AND pbt.balance_type_id=pdb.balance_type_id