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_PAYSLIP_ARCHIVE dependencies on PAY_BALANCE_DIMENSIONS

Line 16: database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,

12: balance_dimension_id NUMBER,
13: defined_balance_id NUMBER,
14: balance_narrative VARCHAR2(30),
15: balance_name pay_balance_types.balance_name%TYPE,
16: database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,
17: si_type hr_lookups.meaning%TYPE,
18: legislation_code pay_balance_dimensions.legislation_code%TYPE);
19:
20: TYPE element_rec IS RECORD (

Line 18: legislation_code pay_balance_dimensions.legislation_code%TYPE);

14: balance_narrative VARCHAR2(30),
15: balance_name pay_balance_types.balance_name%TYPE,
16: database_item_suffix pay_balance_dimensions.database_item_suffix%TYPE,
17: si_type hr_lookups.meaning%TYPE,
18: legislation_code pay_balance_dimensions.legislation_code%TYPE);
19:
20: TYPE element_rec IS RECORD (
21: element_type_id NUMBER,
22: input_value_id NUMBER,

Line 77: FROM pay_balance_dimensions pbd

73: ,p_dimension_name VARCHAR2) RETURN NUMBER AS
74: --
75: CURSOR csr_defined_balance_id is
76: SELECT pdb.defined_balance_id
77: FROM pay_balance_dimensions pbd
78: ,pay_balance_types pbt
79: ,pay_defined_balances pdb
80: WHERE pbd.database_item_suffix = p_dimension_name
81: AND pbd.business_group_id is null

Line 366: pay_balance_dimensions pbd,

362: pbd.database_item_suffix,
363: pbt.legislation_code,
364: pdb.defined_balance_id
365: FROM pay_balance_types pbt,
366: pay_balance_dimensions pbd,
367: pay_defined_balances pdb
368: WHERE pdb.balance_type_id = pbt.balance_type_id
369: AND pdb.balance_dimension_id = pbd.balance_dimension_id
370: AND pbt.balance_type_id = p_balance_type_id

Line 2711: FROM pay_balance_dimensions pbd

2707: CURSOR csr_defined_balance_id (p_balance_name VARCHAR2
2708: ,p_dimension VARCHAR2
2709: ,p_bus_group_id NUMBER) IS
2710: SELECT pdb.defined_balance_id defined_balance_id
2711: FROM pay_balance_dimensions pbd
2712: ,pay_balance_types pbt
2713: ,pay_defined_balances pdb
2714: WHERE pbd.database_item_suffix = p_dimension
2715: AND pbt.balance_name = p_balance_name