DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PAY_BALANCE_DIMENSIONS

Line 2333: pay_balance_dimensions pbd

2329: cursor csr_def_bal_id(p_assignment_action_id number) is
2330: select defined_balance_id
2331: from pay_defined_balances pdb,
2332: pay_balance_types pbt,
2333: pay_balance_dimensions pbd
2334: where pbt.balance_name = 'NI '||(select ACTION_INFORMATION23
2335: from pay_action_information pai
2336: where pai.action_context_id = p_assignment_action_id --182069
2337: and pai.action_information_category = 'GB EMPLOYEE DETAILS'

Line 2365: pay_balance_dimensions pbd

2361: cursor csr_netpay_bal_id is
2362: select defined_balance_id
2363: from pay_defined_balances pdb,
2364: pay_balance_types pbt,
2365: pay_balance_dimensions pbd
2366: where pbt.balance_name = 'Net Pay'
2367: and pbd.dimension_name = '_ASG_TD_YTD'
2368: and pdb.balance_type_id = pbt.balance_type_id
2369: and pdb.balance_dimension_id = pbd.balance_dimension_id