APPS.PY_ZA_TX_01032012 dependencies on PAY_BALANCE_DIMENSIONS

Line 128: , pay_balance_dimensions pbd

124: p_dim_name varchar2) return number is
125: cursor c_get_def_bal_id is
126: SELECT pdb.defined_balance_id
127: FROM pay_balance_types pbt
128: , pay_balance_dimensions pbd
129: , pay_defined_balances pdb
130: WHERE pbt.balance_name = p_bal_name
131: AND pbd.dimension_name = p_dim_name
132: AND pdb.balance_type_id = pbt.balance_type_id

Line 1347: l_dimension pay_balance_dimensions.dimension_name%TYPE ;

1343: AS
1344: -- Variables
1345: l_BalVal BALANCE;
1346: l_BalTypId pay_balance_types.balance_type_id%TYPE;
1347: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
1348:
1349: BEGIN
1350: hr_utility.set_location('py_za_tx_01032012.LteCalc',1);
1351: -- Get the Balance Type ID

Line 1379: l_dimension pay_balance_dimensions.dimension_name%TYPE ;

1375: AS
1376: -- Variables
1377: l_BalVal BALANCE;
1378: l_BalTypId pay_balance_types.balance_type_id%TYPE;
1379: l_dimension pay_balance_dimensions.dimension_name%TYPE ;
1380: BEGIN
1381: hr_utility.set_location('py_za_tx_01032012.LteCalc',3);
1382: -- Get the Balance Type ID
1383: SELECT pbt.balance_type_id