APPS.HR_ACCRUAL_PLAN_API dependencies on PAY_BALANCE_DIMENSIONS

Line 340: pay_balance_dimensions pbd,

336: cursor c_get_dbi is
337: select distinct dbi.user_name
338: from ff_database_items dbi,
339: ff_user_entities ue,
340: pay_balance_dimensions pbd,
341: pay_defined_balances dfb,
342: pay_balance_types pbt
343: where dfb.balance_dimension_id = pbd.balance_dimension_id
344: and pbd.route_id = ue.route_id

Line 569: FROM pay_balance_dimensions pbd

565: -- Validates the balance dimension.
566: --
567: CURSOR csr_chk_bal_dim IS
568: SELECT NULL
569: FROM pay_balance_dimensions pbd
570: WHERE pbd.balance_dimension_id = p_balance_dimension_id
571: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
572: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
573: = NVL(l_legislation_code, hr_api.g_varchar2)

Line 596: FROM pay_balance_dimensions pbd

592: AND frcu.route_id = fr.route_id
593: AND frcu.context_id = fc.context_id)
594: UNION ALL
595: SELECT NULL
596: FROM pay_balance_dimensions pbd
597: WHERE pbd.balance_dimension_id = p_balance_dimension_id
598: AND NVL(pbd.business_group_id, p_business_group_id) = p_business_group_id
599: AND NVL(pbd.legislation_code, NVL(l_legislation_code, hr_api.g_varchar2))
600: = NVL(l_legislation_code, hr_api.g_varchar2)