APPS.PAY_TIME_DEFINITION_API dependencies on PER_TIME_PERIODS

Line 42: l_period_name per_time_periods.period_name%type ;

38:
39: l_multiple number;
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:

Line 79: from per_time_periods ptp

75: cursor csr_existing_period_details is
76: select min(start_date),
77: max(end_date),
78: count(time_period_id)
79: from per_time_periods ptp
80: where ptp.time_definition_id = p_time_definition_id;
81:
82: cursor csr_first_period_end_date is
83: select end_date

Line 84: from per_time_periods ptp

80: where ptp.time_definition_id = p_time_definition_id;
81:
82: cursor csr_first_period_end_date is
83: select end_date
84: from per_time_periods ptp
85: where ptp.time_definition_id = p_time_definition_id
86: and start_date = l_first_period_start_date;
87:
88: --

Line 371: insert into per_time_periods

367: fnd_message.set_name('PAY','PAY_33414_FLSA_CROSS_VAL3');
368: fnd_message.raise_error;
369: End if;
370:
371: insert into per_time_periods
372: (time_period_id,
373: start_date,
374: end_date,
375: period_type,

Line 381: per_time_periods_s.nextval,

377: period_name,
378: time_definition_id
379: )
380: select
381: per_time_periods_s.nextval,
382: l_period_start_date,
383: l_period_end_date,
384: l_period_type,
385: l_period_number,

Line 697: delete from per_time_periods

693: close csr_definition_type;
694:
695: if l_definition_type not in ('P', 'E', 'C') then
696:
697: delete from per_time_periods
698: where time_definition_id = p_time_definition_id;
699:
700: generate_time_periods
701: (p_time_definition_id => p_time_definition_id);

Line 829: delete from per_time_periods

825: --
826: -- Process Logic
827: --
828:
829: delete from per_time_periods
830: where time_definition_id = p_time_definition_id;
831:
832: delete from pay_time_def_usages
833: where time_definition_id = p_time_definition_id;