eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_TYPES

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

1320: l_period NUMBER;
1321: l_payroll_name pay_payrolls_f.payroll_name%TYPE;
1322: l_payroll_id NUMBER;
1323: l_tan hr_organization_information.org_information1%TYPE;
1324: TYPE r_balance_name_val IS RECORD(l_balance_name pay_balance_types.balance_name%type,
1325: l_balance_val NUMBER);
1326: TYPE t_balance IS TABLE OF r_balance_name_val INDEX BY PLS_INTEGER;
1327: l_bal_name_val t_balance;
1328: l_add_to_net_flag VARCHAR2(10) := NULL;

Line 2027: from pay_balance_types pbt

2023: Cursor c_defined_balance_id(p_balance_name VARCHAR2
2024: ,p_dimension VARCHAR2)
2025: IS
2026: select pdb.defined_balance_id
2027: from pay_balance_types pbt
2028: ,pay_balance_dimensions pbd
2029: ,pay_defined_balances pdb
2030: where pbt.balance_name=p_balance_name
2031: and pbd.dimension_name=p_dimension

Line 2700: FROM pay_balance_types pbt

2696: CURSOR c_defined_balance_id(p_balance_name VARCHAR2
2697: ,p_dimension VARCHAR2)
2698: IS
2699: SELECT pdb.defined_balance_id
2700: FROM pay_balance_types pbt
2701: ,pay_balance_dimensions pbd
2702: ,pay_defined_balances pdb
2703: WHERE pbt.balance_name=p_balance_name
2704: AND pbd.dimension_name=p_dimension