APPS.PAY_MX_UTILITY dependencies on FND_SESSIONS

Line 445: FROM fnd_sessions

441: lv_proc VARCHAR2(240);
442:
443: CURSOR c_actual_days_of_month IS
444: SELECT TO_NUMBER(TO_CHAR(LAST_DAY(effective_date),'DD'))
445: FROM fnd_sessions
446: WHERE session_id = USERENV('SESSIONID') ;
447:
448: BEGIN
449:

Line 491: -- actual number of days is taken from the effective date of fnd_sessions

487:
488: ELSIF (p_mode = 'MONTH' AND ln_days_month IS NULL) THEN
489:
490: -- Changed the logic to get the actual number of days of the month
491: -- actual number of days is taken from the effective date of fnd_sessions
492: -- as payroll being processed the effective_date will be inserted in the
493: -- fnd_sessions table
494:
495: OPEN c_actual_days_of_month ;

Line 493: -- fnd_sessions table

489:
490: -- Changed the logic to get the actual number of days of the month
491: -- actual number of days is taken from the effective date of fnd_sessions
492: -- as payroll being processed the effective_date will be inserted in the
493: -- fnd_sessions table
494:
495: OPEN c_actual_days_of_month ;
496: FETCH c_actual_days_of_month INTO ln_days_month ;
497: -- some reason it gets null then defaulting it to 30 average number of days

Line 645: from fnd_sessions

641:
642: CURSOR c_get_days_total IS
643: SELECT to_number(to_char(effective_date,'DD')),
644: to_number(to_char(last_day(effective_date),'DD'))
645: from fnd_sessions
646: where session_id = USERENV('sessionid') ;
647:
648:
649: lv_prd_type VARCHAR2(150);

Line 749: from fnd_sessions

745:
746: CURSOR c_get_days_in_bimonth IS
747: SELECT to_number(to_char(last_day(ADD_MONTHS(effective_date,-1)),'DD')) +
748: to_number(to_char(last_day(effective_date),'DD'))
749: from fnd_sessions
750: where session_id = USERENV('sessionid') ;
751:
752: BEGIN
753: