DBA Data[Home] [Help]

APPS.PAY_GB_BACS_TAPE dependencies on HR_GENERAL

Line 62: Bug 572935 hr_general.decode_lookup

58: 30-JUL-96 JALLOUN 40.2 Added error handling.
59: 26-NOV-97 APARKES 110.1 Bug 572503 removed to_date
60: functions in cursor Payment_rule
61: in validate_process_date function
62: Bug 572935 hr_general.decode_lookup
63: used to decode return from get_banks
64: cursor. Same as UK arcs (R10) v40.14
65: 12-DEC-97 APARKES 110.2 599470 Removed use of to_date in the cursor in
66: function check_hols when restricting by

Line 606: if p_entry_date = hr_general.start_of_time then

602: l_day_diff number(2); -- difference between the days
603: --
604: BEGIN
605: --
606: if p_entry_date = hr_general.start_of_time then
607: open csr_get_default_date;
608: fetch csr_get_default_date into l_dd_date;
609: close csr_get_default_date;
610: else

Line 728: sql_str := hr_general.decode_lookup('GB_COUNTRY',sql_str);

724: if get_banks%FOUND or get_banks%ROWCOUNT = 0 then
725: if sql_str is NULL then
726: sql_str := 'England';
727: else
728: sql_str := hr_general.decode_lookup('GB_COUNTRY',sql_str);
729: end if;
730: dd_date := main_routine (dd_date, sql_str);
731: if dd_date < lowest_dd_date then
732: lowest_dd_date := dd_date;