APPS.PAY_CORE_DATES dependencies on PAY_TIME_DEFINITIONS

Line 85: l_period_type pay_time_definitions.period_type%type;

81:
82: is
83: l_return_date date;
84: --
85: l_period_type pay_time_definitions.period_type%type;
86: l_period_unit pay_time_definitions.period_unit%type;
87: l_day_adjustment pay_time_definitions.day_adjustment%type;
88: l_period_date date;
89: /* Bug 13537723, code changes start */

Line 86: l_period_unit pay_time_definitions.period_unit%type;

82: is
83: l_return_date date;
84: --
85: l_period_type pay_time_definitions.period_type%type;
86: l_period_unit pay_time_definitions.period_unit%type;
87: l_day_adjustment pay_time_definitions.day_adjustment%type;
88: l_period_date date;
89: /* Bug 13537723, code changes start */
90: l_dynamic_code pay_time_definitions.dynamic_code%type;

Line 87: l_day_adjustment pay_time_definitions.day_adjustment%type;

83: l_return_date date;
84: --
85: l_period_type pay_time_definitions.period_type%type;
86: l_period_unit pay_time_definitions.period_unit%type;
87: l_day_adjustment pay_time_definitions.day_adjustment%type;
88: l_period_date date;
89: /* Bug 13537723, code changes start */
90: l_dynamic_code pay_time_definitions.dynamic_code%type;
91: l_statem varchar2(2000); -- used with dynamic pl/sql

Line 90: l_dynamic_code pay_time_definitions.dynamic_code%type;

86: l_period_unit pay_time_definitions.period_unit%type;
87: l_day_adjustment pay_time_definitions.day_adjustment%type;
88: l_period_date date;
89: /* Bug 13537723, code changes start */
90: l_dynamic_code pay_time_definitions.dynamic_code%type;
91: l_statem varchar2(2000); -- used with dynamic pl/sql
92: sql_cursor integer;
93: l_rows integer;
94: /* Bug 13537723, code changes end */

Line 108: from pay_time_definitions

104: into l_period_type,
105: l_period_unit,
106: l_day_adjustment,
107: l_dynamic_code
108: from pay_time_definitions
109: where time_definition_id = p_time_def_id;
110: --
111: --
112: get_offset_date(l_period_type,