[Home] [Help]
37: T Grisco 03-OCT-1995 Fixed problem with multiple business groups.
38: T Grisco 03-OCT-1995 Removed business group name as a parameter.
39: T Grisco 03-OCT-1995 Changed some local variables' types.
40: T Grisco 16-MAY-1996 Fixed bug #366661 where selecting from
41: pay_balance_feeds_f returns more than 1 row
42: because it's date-tracked.
43: T Grisco 25-MAY-1996 Fixed performance bug #368631.
44: N Bristow 17-JUN-1996 Bug 374880. Changed structure creation to
45: make use of pl/sql tables to improve
334: l_elem_link_id pay_element_links.element_link_id%TYPE;
335: l_input_val_id pay_input_values.input_value_id%TYPE;
336: l_bal_name pay_balance_types.balance_name%TYPE;
337: l_bal_type_id pay_balance_types.balance_type_id%TYPE;
338: l_bal_feed_id pay_balance_feeds.balance_feed_id%TYPE;
339: l_bg_name hr_organization_units.name%TYPE;
340: l_bg_id hr_organization_units.organization_id%TYPE;
341: l_jur_level number;
342: l_jur_count number;
348: cursor csr_is_balance_fed (p_balance_type_id number,
349: p_business_group number)
350: is
351: select balance_feed_id
352: from pay_balance_feeds_f BF,
353: pay_input_values_f IV,
354: pay_element_types_f ET,
355: pay_element_classifications EC
356: where EC.balance_initialization_flag = 'Y'