APPS.PAY_GB_COURT_ORDER_UPGRADE dependencies on PER_BUSINESS_GROUPS

Line 190: FROM per_business_groups

186: -- To get business_group name
187: CURSOR csr_business_group
188: is
189: SELECT name
190: FROM per_business_groups
191: WHERE business_group_id =p_bg_id;
192:
193: -- To get date
194: CURSOR csr_date

Line 329: l_business_group_name per_business_groups.name%type;

325:
326:
327: v_initial_det csr_intial_debt%rowtype;
328: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
329: l_business_group_name per_business_groups.name%type;
330: v_payroll pay_payrolls_f.payroll_name%type;
331:
332: l_overpaid_flag varchar2(1);
333: l_no_data_found varchar2(1);