APPS.PAY_PAYJPSMT_XMLP_PKG dependencies on FF_GLOBALS_F

Line 392: l_global_id ff_globals_f.global_id%type;

388: p_business_group_id in number,
389: p_legislation_code in varchar2,
390: p_effective_date in date) return number
391: is
392: l_global_id ff_globals_f.global_id%type;
393: l_global_value ff_globals_f.global_value%type;
394: cursor get_global_value
395: is
396: select to_number(decode(fg.data_type,'N',fg.global_value,null))

Line 393: l_global_value ff_globals_f.global_value%type;

389: p_legislation_code in varchar2,
390: p_effective_date in date) return number
391: is
392: l_global_id ff_globals_f.global_id%type;
393: l_global_value ff_globals_f.global_value%type;
394: cursor get_global_value
395: is
396: select to_number(decode(fg.data_type,'N',fg.global_value,null))
397: from ff_globals_f fg

Line 397: from ff_globals_f fg

393: l_global_value ff_globals_f.global_value%type;
394: cursor get_global_value
395: is
396: select to_number(decode(fg.data_type,'N',fg.global_value,null))
397: from ff_globals_f fg
398: where fg.global_id = l_global_id
399: and p_effective_date
400: between fg.effective_start_date and fg.effective_end_date;
401: function get_global_id(

Line 411: from ff_globals_f fg

407: l_global_id number;
408: cursor get_global_id
409: is
410: select min(global_id)
411: from ff_globals_f fg
412: where fg.global_name = p_global_name
413: and nvl(fg.business_group_id,nvl(p_business_group_id,-1)) = nvl(p_business_group_id,-1)
414: and nvl(fg.legislation_code,nvl(p_legislation_code,'JP')) = nvl(p_legislation_code,'JP');
415: begin