DBA Data[Home] [Help]

APPS.PAY_CORE_DATES dependencies on PAY_TIME_DEFINITIONS

Line 81: l_period_type pay_time_definitions.period_type%type;

77: p_bus_grp in number default null)
78: is
79: l_return_date date;
80: --
81: l_period_type pay_time_definitions.period_type%type;
82: l_period_unit pay_time_definitions.period_unit%type;
83: l_day_adjustment pay_time_definitions.day_adjustment%type;
84: l_period_date date;
85: --

Line 82: l_period_unit pay_time_definitions.period_unit%type;

78: is
79: l_return_date date;
80: --
81: l_period_type pay_time_definitions.period_type%type;
82: l_period_unit pay_time_definitions.period_unit%type;
83: l_day_adjustment pay_time_definitions.day_adjustment%type;
84: l_period_date date;
85: --
86: begin

Line 83: l_day_adjustment pay_time_definitions.day_adjustment%type;

79: l_return_date date;
80: --
81: l_period_type pay_time_definitions.period_type%type;
82: l_period_unit pay_time_definitions.period_unit%type;
83: l_day_adjustment pay_time_definitions.day_adjustment%type;
84: l_period_date date;
85: --
86: begin
87: g_debug := hr_utility.debug_enabled;

Line 95: from pay_time_definitions

91: nvl(day_adjustment,0)
92: into l_period_type,
93: l_period_unit,
94: l_day_adjustment
95: from pay_time_definitions
96: where time_definition_id = p_time_def_id;
97: --
98: --
99: get_offset_date(l_period_type,