DBA Data[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on FND_SESSIONS

Line 476: ** gets the effective_date from fnd_sessions. If the date

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)

Line 477: ** in fnd_sessions is not found, get the data as of sysdate.

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

Line 485: select effective_date from fnd_sessions fs

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: