eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on STANDARD

Line 109: -- element entry for LEAVE_INFORMATION -> STANDARD WORK WEEK

105: where assignment_id = p_assignment_id
106: and p_calculation_date between effective_start_date and effective_end_date;
107: --
108: -- Cursor to retrieve the input value of
109: -- element entry for LEAVE_INFORMATION -> STANDARD WORK WEEK
110: --
111: cursor csr_work_week
112: (p_assignment_id number
113: ,p_effective_date date

Line 130: and piv.name = 'Standard Work Week'

126: and el.element_name = 'Leave Information'
127: and el.legislation_code = g_legislation_code
128: and p_effective_date between el.effective_start_date and el.effective_end_date
129: and el.element_type_id = piv.element_type_id
130: and piv.name = 'Standard Work Week'
131: and p_effective_date between piv.effective_start_date and piv.effective_end_date
132: and val.input_value_id = piv.input_value_id
133: and p_effective_date between val.effective_start_date and val.effective_end_date;
134: --

Line 373: -- GET_STANDARD_WORK_WEEK

369: return l_value;
370: end get_balance;
371: --
372: --------------------
373: -- GET_STANDARD_WORK_WEEK
374: --------------------
375: --
376: function get_standard_work_week
377: (p_assignment_id in number

Line 376: function get_standard_work_week

372: --------------------
373: -- GET_STANDARD_WORK_WEEK
374: --------------------
375: --
376: function get_standard_work_week
377: (p_assignment_id in number
378: ,p_effective_date in date
379: ) return number is
380: l_procedure constant varchar2(100) := g_package||'get_standard_week';

Line 380: l_procedure constant varchar2(100) := g_package||'get_standard_week';

376: function get_standard_work_week
377: (p_assignment_id in number
378: ,p_effective_date in date
379: ) return number is
380: l_procedure constant varchar2(100) := g_package||'get_standard_week';
381: l_standard_days_per_week number;
382: begin
383: --
384: open csr_work_week(p_assignment_id, p_effective_date);

Line 381: l_standard_days_per_week number;

377: (p_assignment_id in number
378: ,p_effective_date in date
379: ) return number is
380: l_procedure constant varchar2(100) := g_package||'get_standard_week';
381: l_standard_days_per_week number;
382: begin
383: --
384: open csr_work_week(p_assignment_id, p_effective_date);
385: fetch csr_work_week

Line 386: into l_standard_days_per_week;

382: begin
383: --
384: open csr_work_week(p_assignment_id, p_effective_date);
385: fetch csr_work_week
386: into l_standard_days_per_week;
387: if csr_work_week%notfound then
388: l_standard_days_per_week := 0;
389: end if;
390: close csr_work_week;

Line 388: l_standard_days_per_week := 0;

384: open csr_work_week(p_assignment_id, p_effective_date);
385: fetch csr_work_week
386: into l_standard_days_per_week;
387: if csr_work_week%notfound then
388: l_standard_days_per_week := 0;
389: end if;
390: close csr_work_week;
391: --
392: return l_standard_days_per_week;

Line 392: return l_standard_days_per_week;

388: l_standard_days_per_week := 0;
389: end if;
390: close csr_work_week;
391: --
392: return l_standard_days_per_week;
393: end get_standard_work_week;
394: --
395: -------------------
396: -- MOVE_ANNIVERSARY

Line 393: end get_standard_work_week;

389: end if;
390: close csr_work_week;
391: --
392: return l_standard_days_per_week;
393: end get_standard_work_week;
394: --
395: -------------------
396: -- MOVE_ANNIVERSARY
397: -------------------

Line 941: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);

937: if g_debug then
938: hr_utility.set_location(l_procedure,35);
939: end if;
940: --
941: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);
942: --
943: -- If the 'Standard Work Week' is not available
944: -- then we use the balance DAYS_OR_HOURS_WORKED
945: --

Line 943: -- If the 'Standard Work Week' is not available

939: end if;
940: --
941: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);
942: --
943: -- If the 'Standard Work Week' is not available
944: -- then we use the balance DAYS_OR_HOURS_WORKED
945: --
946: if (l_work_week is null) or (l_work_week = 0) then
947: --

Line 1129: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);

1125: if g_debug then
1126: hr_utility.set_location(l_procedure,35);
1127: end if;
1128: --
1129: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);
1130: --
1131: -- If the 'Standard Work Week' is not available
1132: -- then we use the balance DAYS_OR_HOURS_WORKED
1133: --

Line 1131: -- If the 'Standard Work Week' is not available

1127: end if;
1128: --
1129: l_work_week := get_standard_work_week(p_assignment_id => p_assignment_id, p_effective_date => p_current_day);
1130: --
1131: -- If the 'Standard Work Week' is not available
1132: -- then we use the balance DAYS_OR_HOURS_WORKED
1133: --
1134: if (l_work_week is null) or (l_work_week = 0) then
1135: --