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 611: if p_entry_date = hr_general.start_of_time then

607: l_day_diff number(2); -- difference between the days
608: --
609: BEGIN
610: --
611: if p_entry_date = hr_general.start_of_time then
612: open csr_get_default_date;
613: fetch csr_get_default_date into l_dd_date;
614: close csr_get_default_date;
615: else

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

729: if get_banks%FOUND or get_banks%ROWCOUNT = 0 then
730: if sql_str is NULL then
731: sql_str := 'England';
732: else
733: sql_str := hr_general.decode_lookup('GB_COUNTRY',sql_str);
734: end if;
735: dd_date := main_routine (dd_date, sql_str);
736: if dd_date < lowest_dd_date then
737: lowest_dd_date := dd_date;