472: ** Arguments: p_jurisdiction_code
473: ** p_tax_type
474: ** Returns : Y/N
475: ** Purpose : This function has 2 parameters as input. The function
476: ** gets the effective_date from fnd_sessions. If the date
477: ** in fnd_sessions is not found, get the data as of sysdate.
478: *********************************************************************/
479: FUNCTION get_tax_exists (p_jurisdiction_code in varchar2
480: ,p_tax_type in varchar2)
473: ** p_tax_type
474: ** Returns : Y/N
475: ** Purpose : This function has 2 parameters as input. The function
476: ** gets the effective_date from fnd_sessions. If the date
477: ** in fnd_sessions is not found, get the data as of sysdate.
478: *********************************************************************/
479: FUNCTION get_tax_exists (p_jurisdiction_code in varchar2
480: ,p_tax_type in varchar2)
481: RETURN varchar2
481: RETURN varchar2
482: IS
483:
484: cursor c_sessions is
485: select effective_date from fnd_sessions fs
486: where session_id = userenv('sessionid');
487:
488: ld_effective_date DATE;
489: