APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES

Line 1223: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,

1219: l_period NUMBER;
1220: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1221: l_payroll_id NUMBER;
1222: l_tan hr_organization_information.org_information1%TYPE;
1223: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1224: l_balance_val NUMBER);
1225: TYPE t_balance IS TABLE OF r_balance_name_val INDEX BY PLS_INTEGER;
1226: l_bal_name_val t_balance;
1227: BEGIN

Line 1878: from pay_balance_types pbt

1874: Cursor c_defined_balance_id(p_balance_name VARCHAR2
1875: ,p_dimension VARCHAR2)
1876: IS
1877: select pdb.defined_balance_id
1878: from pay_balance_types pbt
1879: ,pay_balance_dimensions pbd
1880: ,pay_defined_balances pdb
1881: where pbt.balance_name=p_balance_name
1882: and pbd.dimension_name=p_dimension

Line 2488: FROM pay_balance_types pbt

2484: CURSOR c_defined_balance_id(p_balance_name VARCHAR2
2485: ,p_dimension VARCHAR2)
2486: IS
2487: SELECT pdb.defined_balance_id
2488: FROM pay_balance_types pbt
2489: ,pay_balance_dimensions pbd
2490: ,pay_defined_balances pdb
2491: WHERE pbt.balance_name=p_balance_name
2492: AND pbd.dimension_name=p_dimension