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 330: l_business_group_name per_business_groups.name%type;

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