DBA Data[Home] [Help]

APPS.PAY_IE_EOY_INCOMELEVY_REPORT dependencies on PAY_BALANCE_DIMENSIONS

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

431: AND paa.source_action_id is null
432: AND ppa.effective_date between cp_start_date and cp_end_date;
433:
434: cursor cur_defined_balance_id (c_balance_name pay_balance_types.balance_name%type
435: ,c_dimension_name pay_balance_dimensions.database_item_suffix%type) is
436: select pdb.defined_balance_id
437: from pay_defined_balances pdb
438: ,pay_balance_dimensions pbd
439: ,pay_balance_types pbt

Line 438: ,pay_balance_dimensions pbd

434: cursor cur_defined_balance_id (c_balance_name pay_balance_types.balance_name%type
435: ,c_dimension_name pay_balance_dimensions.database_item_suffix%type) is
436: select pdb.defined_balance_id
437: from pay_defined_balances pdb
438: ,pay_balance_dimensions pbd
439: ,pay_balance_types pbt
440:
441: WHERE pbt.balance_name=c_balance_name
442: AND pbt.balance_type_id=pdb.balance_type_id