APPS.PAY_NL_WTS_REPORT dependencies on PAY_DEFINED_BALANCES

Line 108: pay_defined_balances pdb

104: cursor Csr_Get_Defined_Balance_Id(l_balance_name Varchar2) is
105: select pdb.defined_balance_id
106: from pay_balance_dimensions pbd,
107: pay_balance_types pbt,
108: pay_defined_balances pdb
109: where pbt.balance_type_id = pdb.balance_type_id
110: and pbt.balance_name =l_balance_name
111: and pbd.balance_dimension_id = pdb.balance_dimension_id
112: and pbd.database_item_suffix='_PER_PAY_PTD'

Line 114: l_Defined_Balance_Id pay_defined_balances.defined_balance_id%TYPE;

110: and pbt.balance_name =l_balance_name
111: and pbd.balance_dimension_id = pdb.balance_dimension_id
112: and pbd.database_item_suffix='_PER_PAY_PTD'
113: and pbt.legislation_code='NL';
114: l_Defined_Balance_Id pay_defined_balances.defined_balance_id%TYPE;
115: BEGIN
116: OPEN Csr_Get_Defined_Balance_Id(p_balance_name);
117: FETCH Csr_Get_Defined_Balance_Id INTO l_Defined_Balance_Id;
118: CLOSE Csr_Get_Defined_Balance_Id;