DBA Data[Home] [Help]

APPS.PAY_GB_HR_HELPDESK dependencies on PAY_BALANCE_DIMENSIONS

Line 283: pay_balance_dimensions pbd

279: cursor csr_def_bal_id(p_assignment_action_id number) is
280: select defined_balance_id
281: from pay_defined_balances pdb,
282: pay_balance_types pbt,
283: pay_balance_dimensions pbd
284: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
285: from pay_action_information pai
286: where pai.action_context_id = p_assignment_action_id --182069
287: and pai.action_information_category = 'GB EMPLOYEE DETAILS'

Line 316: pay_balance_dimensions pbd

312: cursor csr_netpay_bal_id is
313: select defined_balance_id
314: from pay_defined_balances pdb,
315: pay_balance_types pbt,
316: pay_balance_dimensions pbd
317: where pbt.balance_name = 'Net Pay'
318: and pbd.dimension_name = '_ASG_TD_YTD'
319: and pdb.balance_type_id = pbt.balance_type_id
320: and pdb.balance_dimension_id = pbd.balance_dimension_id