APPS.PAY_FR_BAL_UPLOAD dependencies on PER_BUSINESS_GROUPS_PERF

Line 270: l_business_group_name per_business_groups_perf.name%TYPE;

266: type t_cxt_ivs is table of t_cxt_iv index by binary_integer;
267: tbl_cxt_ivs t_cxt_ivs;
268: --
269: l_num_cxts number := 0;
270: l_business_group_name per_business_groups_perf.name%TYPE;
271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;
273: l_prev_currency_code pay_balance_types.currency_code%TYPE;
274: l_element_type_id pay_element_types_f.element_type_id%TYPE;

Line 271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;

267: tbl_cxt_ivs t_cxt_ivs;
268: --
269: l_num_cxts number := 0;
270: l_business_group_name per_business_groups_perf.name%TYPE;
271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;
273: l_prev_currency_code pay_balance_types.currency_code%TYPE;
274: l_element_type_id pay_element_types_f.element_type_id%TYPE;
275: l_element_name pay_element_types_f.element_name%TYPE;

Line 272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;

268: --
269: l_num_cxts number := 0;
270: l_business_group_name per_business_groups_perf.name%TYPE;
271: l_legislation_code per_business_groups_perf.legislation_code%TYPE;
272: l_BG_currency_code per_business_groups_perf.currency_code%TYPE;
273: l_prev_currency_code pay_balance_types.currency_code%TYPE;
274: l_element_type_id pay_element_types_f.element_type_id%TYPE;
275: l_element_name pay_element_types_f.element_name%TYPE;
276: l_element_counter number;

Line 288: per_business_groups_perf pbg

284: pbg.name,
285: pbg.legislation_code,
286: pbg.currency_code
287: from
288: per_business_groups_perf pbg
289: where pbg.business_group_id = p_business_group_id;
290: --
291: Cursor csr_cxt_ivs is
292: select lc.input_value_name,