DBA Data[Home] [Help]

APPS.PAY_JP_DIMENSION_GENERATOR_PKG dependencies on PAY_BALANCE_DIMENSIONS_S

Line 312: l_start_date_code pay_balance_dimensions.start_date_code%type;

308: l_dimension_type pay_balance_dimensions.dimension_type%type;
309: l_expiry_checking_level pay_balance_dimensions.expiry_checking_level%type;
310: l_expiry_checking_code pay_balance_dimensions.expiry_checking_code%type;
311: l_period_type pay_balance_dimensions.period_type%type;
312: l_start_date_code pay_balance_dimensions.start_date_code%type;
313: begin
314: l_route_id := get_route_id('Core Balance Route No Contexts');
315: l_description := get_description(p_date_type, p_reset_date, p_frequency_type, p_frequency, p_exclude_reversal);
316: --

Line 359: select pay_balance_dimensions_s.nextval

355: l_period_type := 'DYNAMIC';
356: l_start_date_code := get_start_date_code(p_date_type, p_reset_date, p_frequency_type, p_frequency);
357: --
358: if p_balance_dimension_id is null then
359: select pay_balance_dimensions_s.nextval
360: into p_balance_dimension_id
361: from dual;
362: --
363: insert into pay_balance_dimensions(