APPS.PAY_IE_CESS_REPORT dependencies on PAY_DEFINED_BALANCES

Line 290: from pay_defined_balances pdb

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
292: ,pay_balance_types pbt
293:
294: WHERE pbt.balance_name=c_balance_name

Line 405: l_defined_balance_id pay_defined_balances.defined_balance_id%type;

401: AND ppa.action_type in ('Q','B','R','I','V')
402: AND ppa.action_status ='C'
403: AND paa.source_action_id is null
404: AND ppa.effective_date<= to_date('30/04/2009','dd/mm/yyyy');
405: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
406: l_balance_value NUMBER:=0;
407: l_balance_value1 NUMBER:=0;
408: /* 8615992 */
409: l_assignment_action_apr_09 pay_assignment_actions.assignment_action_id%type;