APPS.PAY_FR_BAL_UPLOAD dependencies on PAY_BALANCE_TYPES

Line 273: l_prev_currency_code pay_balance_types.currency_code%TYPE;

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;
277: l_element_link_id number;

Line 308: from pay_balance_types pbt2

304: select pbt2.balance_type_id id,
305: pbt2.balance_name name,
306: pbt2.balance_uom uom,
307: nvl(pbt2.currency_code,l_BG_currency_code) currency_code
308: from pay_balance_types pbt2
309: where pbt2.balance_type_id in (select pbt.balance_type_id
310: from pay_balance_batch_lines bbl,
311: pay_balance_types pbt
312: where bbl.batch_id = p_batch_id

Line 311: pay_balance_types pbt

307: nvl(pbt2.currency_code,l_BG_currency_code) currency_code
308: from pay_balance_types pbt2
309: where pbt2.balance_type_id in (select pbt.balance_type_id
310: from pay_balance_batch_lines bbl,
311: pay_balance_types pbt
312: where bbl.batch_id = p_batch_id
313: and (bbl.balance_type_id = pbt.balance_type_id or
314: (bbl.balance_type_id is null
315: and upper(pbt.balance_name) = upper(bbl.balance_name)))