DBA Data[Home] [Help]

APPS.PAY_TIME_DEFINITION_API dependencies on PER_TIME_PERIOD_TYPES

Line 44: l_display_period_type per_time_period_types.display_period_type%type ;

40: l_base_period_type varchar2(1);
41: l_period_number number;
42: l_period_name per_time_periods.period_name%type ;
43: l_end_years_marker date;
44: l_display_period_type per_time_period_types.display_period_type%type ;
45: l_date date;
46:
47: l_next_leg_start_date date;
48: l_leg_start_date date;

Line 326: from per_time_period_types_vl tpt

322: begin
323:
324: select NVL(tpt.display_period_type, l_period_type)
325: into l_display_period_type
326: from per_time_period_types_vl tpt
327: where tpt.period_type = l_period_type;
328:
329: l_period_name := to_char(l_period_number) || ' '
330: || to_char(l_period_end_date, 'YYYY') || ' '