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.PQP_NL_PENSION_EXTRACTS dependencies on PAY_BALANCE_DIMENSIONS

Line 135: ,pay_balance_dimensions bd

131: ,c_business_group_id IN Number) IS
132: SELECT db.defined_balance_id
133: FROM pay_balance_types pbt
134: ,pay_defined_balances db
135: ,pay_balance_dimensions bd
136: WHERE pbt.balance_name = c_balance_name
137: AND pbt.balance_type_id = db.balance_type_id
138: AND bd.balance_dimension_id = db.balance_dimension_id
139: AND bd.dimension_name = c_dimension_name

Line 153: ,pay_balance_dimensions bd

149: ,c_dimension_name IN Varchar2
150: ,c_business_group_id IN Number) IS
151: SELECT db.defined_balance_id
152: FROM pay_defined_balances db
153: ,pay_balance_dimensions bd
154: WHERE db.balance_type_id = c_balance_type_id
155: AND bd.balance_dimension_id = db.balance_dimension_id
156: AND bd.dimension_name = c_dimension_name
157: AND (db.business_group_id = c_business_group_id OR

Line 3167: FROM pay_balance_dimensions

3163: -- Cursor to get the Assignment Run level dimension id
3164: --
3165: CURSOR csr_asg_dimId IS
3166: SELECT balance_dimension_id
3167: FROM pay_balance_dimensions
3168: WHERE legislation_code = 'NL'
3169: AND database_item_suffix = '_ASG_RUN';
3170:
3171: -- Cursor to check if there is a change in hire date