APPS.PAY_CA_GROUP_LEVEL_BAL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2109: from hr_all_organization_units

2105: AND ROWNUM=1;
2106:
2107: cursor c_get_bg_id1(cp_gre_id number) is
2108: select business_group_id
2109: from hr_all_organization_units
2110: where organization_id = cp_gre_id;
2111:
2112: /* Cursor to get assignment id without the organization_id, location_id,
2113: payroll_id and pay_basis_type parameters and added this cursor

Line 2709: from hr_all_organization_units

2705:
2706: /* new cursor to get business_group_id to fix bug#3637426 */
2707: cursor c_get_bg_id(cp_gre_id number) is
2708: select business_group_id
2709: from hr_all_organization_units
2710: where organization_id = cp_gre_id;
2711:
2712: l_routine_name VARCHAR2(64) := 'pay_ca_group_level_bal_pkg.ca_group_level_balance_rb';
2713: