APPS.PAY_MX_FF_UDFS dependencies on FND_SESSIONS

Line 380: fnd_sessions fs

376: SELECT TPT.number_per_fiscal_year
377: INTO v_periods_per_fiscal_yr
378: FROM pay_payrolls_f PPF,
379: per_time_period_types TPT,
380: fnd_sessions fs
381: WHERE PPF.payroll_id = p_payroll
382: AND fs.session_id = USERENV('SESSIONID')
383: AND fs.effective_date between PPF.effective_start_date
384: and PPF.effective_end_date

Line 404: fnd_sessions fs

400: SELECT TPT.number_per_fiscal_year
401: INTO v_annualizing_factor
402: FROM pay_payrolls_f PRL,
403: per_time_period_types TPT,
404: fnd_sessions fs
405: WHERE TPT.period_type = PRL.period_type
406: and fs.session_id = USERENV('SESSIONID')
407: and fs.effective_date BETWEEN PRL.effective_start_date
408: AND PRL.effective_end_date

Line 462: fnd_sessions fs

458: SELECT TPT.number_per_fiscal_year
459: INTO v_annualizing_factor
460: FROM pay_payrolls_f PRL,
461: per_time_period_types TPT,
462: fnd_sessions fs
463: WHERE TPT.period_type = PRL.period_type
464: AND fs.session_id = USERENV('SESSIONID')
465: AND fs.effective_date BETWEEN PRL.effective_start_date
466: AND PRL.effective_end_date

Line 539: fnd_sessions fs

535: SELECT TPT.number_per_fiscal_year
536: INTO v_periods_per_fiscal_yr
537: FROM pay_payrolls_f ppf,
538: per_time_period_types tpt,
539: fnd_sessions fs
540: WHERE ppf.payroll_id = p_payroll
541: AND fs.session_id = USERENV('SESSIONID')
542: AND fs.effective_date BETWEEN ppf.effective_start_date
543: AND ppf.effective_end_date

Line 791: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

787: --
788: END IF;
789:
790: --
791: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
792: -- record if one doe not already exist.
793: --
794:
795: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')

Line 797: FROM fnd_sessions

793: --
794:
795: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
796: INTO v_fnd_sess_row
797: FROM fnd_sessions
798: WHERE session_id = userenv('sessionid');
799:
800: --
801:

Line 1596: fnd_sessions fs

1592: --{
1593: SELECT period_type
1594: INTO lv_period_type
1595: FROM pay_all_payrolls_f ppf,
1596: fnd_sessions fs
1597: WHERE payroll_id = p_payroll_id
1598: AND fs.effective_date BETWEEN ppf.effective_start_date
1599: AND ppf.effective_end_date
1600: AND fs.session_id = USERENV('sessionid');

Line 1775: fnd_sessions fs

1771:
1772: SELECT period_type
1773: INTO lv_period_type
1774: FROM pay_all_payrolls_f ppf,
1775: fnd_sessions fs
1776: WHERE payroll_id = p_payroll_id
1777: AND fs.effective_date BETWEEN ppf.effective_start_date
1778: AND ppf.effective_end_date
1779: AND fs.session_id = USERENV('sessionid');