DBA Data[Home] [Help]

APPS.PAY_US_PAYROLL_UTILS dependencies on FND_SESSIONS

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

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)

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

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

Line 497: select effective_date from fnd_sessions fs

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: