484: ** Arguments: p_jurisdiction_code
485: ** p_tax_type
486: ** Returns : Y/N
487: ** Purpose : This function has 2 parameters as input. The function
488: ** gets the effective_date from fnd_sessions. If the date
489: ** in fnd_sessions is not found, get the data as of sysdate.
490: *********************************************************************/
491: FUNCTION get_tax_exists (p_jurisdiction_code in varchar2
492: ,p_tax_type in varchar2)
485: ** p_tax_type
486: ** Returns : Y/N
487: ** Purpose : This function has 2 parameters as input. The function
488: ** gets the effective_date from fnd_sessions. If the date
489: ** in fnd_sessions is not found, get the data as of sysdate.
490: *********************************************************************/
491: FUNCTION get_tax_exists (p_jurisdiction_code in varchar2
492: ,p_tax_type in varchar2)
493: RETURN varchar2
493: RETURN varchar2
494: IS
495:
496: cursor c_sessions is
497: select effective_date from fnd_sessions fs
498: where session_id = userenv('sessionid');
499:
500: ld_effective_date DATE;
501: