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_NL_LSS_FUNCTIONS dependencies on PAY_DEFINED_BALANCES

Line 232: TYPE dim_tbl IS TABLE OF pay_defined_balances.DEFINED_BALANCE_ID%TYPE

228: p_bal_total_amt NUMBER := 0;
229: p_person_id NUMBER := 0;
230:
231:
232: TYPE dim_tbl IS TABLE OF pay_defined_balances.DEFINED_BALANCE_ID%TYPE
233: INDEX BY BINARY_INTEGER;
234: L_DEF_BAL_TYPE_ID dim_tbl;
235: CURSOR csr_get_def_bal_type_id
236: (c_balance_name VARCHAR2

Line 239: FROM pay_defined_balances pdb,

235: CURSOR csr_get_def_bal_type_id
236: (c_balance_name VARCHAR2
237: ,c_dimension_name VARCHAR2) IS
238: SELECT defined_balance_id
239: FROM pay_defined_balances pdb,
240: pay_balance_types pbt,
241: pay_balance_dimensions pbd
242: WHERE pbt.balance_name = c_balance_name
243: AND pbd.legislation_code = 'NL'

Line 597: l_def_bal_type_id pay_defined_balances.DEFINED_BALANCE_ID%TYPE;

593: l_balance_amount NUMBER := 0;
594: l_lss_ytd number := 0;
595: l_date date;
596: l_per_ytd VARCHAR2(100) := 'Person Year to Date';
597: l_def_bal_type_id pay_defined_balances.DEFINED_BALANCE_ID%TYPE;
598: l_assignment_exists number := 0; --0 means it doesnot exist, 1 means it exists
599: l_assignment_id_temp number;
600:
601: Cursor c_asg_exists_year(p_year NUMBER, p_assg_id NUMBER) IS

Line 621: FROM pay_defined_balances pdb,

617: CURSOR csr_get_def_bal_type_id
618: (c_balance_name VARCHAR2
619: ,c_dimension_name VARCHAR2) IS
620: SELECT defined_balance_id
621: FROM pay_defined_balances pdb,
622: pay_balance_types pbt,
623: pay_balance_dimensions pbd
624: WHERE pbt.balance_name = c_balance_name
625: AND pbd.legislation_code = 'NL'