APPS.PAY_MX_FF_UDFS dependencies on FND_SESSIONS

Line 393: fnd_sessions fs

389: SELECT TPT.number_per_fiscal_year
390: INTO v_periods_per_fiscal_yr
391: FROM pay_payrolls_f PPF,
392: per_time_period_types TPT,
393: fnd_sessions fs
394: WHERE PPF.payroll_id = p_payroll
395: AND fs.session_id = USERENV('SESSIONID')
396: AND fs.effective_date between PPF.effective_start_date
397: and PPF.effective_end_date

Line 417: fnd_sessions fs

413: SELECT TPT.number_per_fiscal_year
414: INTO v_annualizing_factor
415: FROM pay_payrolls_f PRL,
416: per_time_period_types TPT,
417: fnd_sessions fs
418: WHERE TPT.period_type = PRL.period_type
419: and fs.session_id = USERENV('SESSIONID')
420: and fs.effective_date BETWEEN PRL.effective_start_date
421: AND PRL.effective_end_date

Line 475: fnd_sessions fs

471: SELECT TPT.number_per_fiscal_year
472: INTO v_annualizing_factor
473: FROM pay_payrolls_f PRL,
474: per_time_period_types TPT,
475: fnd_sessions fs
476: WHERE TPT.period_type = PRL.period_type
477: AND fs.session_id = USERENV('SESSIONID')
478: AND fs.effective_date BETWEEN PRL.effective_start_date
479: AND PRL.effective_end_date

Line 552: fnd_sessions fs

548: SELECT TPT.number_per_fiscal_year
549: INTO v_periods_per_fiscal_yr
550: FROM pay_payrolls_f ppf,
551: per_time_period_types tpt,
552: fnd_sessions fs
553: WHERE ppf.payroll_id = p_payroll
554: AND fs.session_id = USERENV('SESSIONID')
555: AND fs.effective_date BETWEEN ppf.effective_start_date
556: AND ppf.effective_end_date

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

800: --
801: END IF;
802:
803: --
804: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this
805: -- record if one doe not already exist.
806: --
807:
808: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')

Line 810: FROM fnd_sessions

806: --
807:
808: SELECT DECODE(COUNT(session_id), 0, 'N', 'Y')
809: INTO v_fnd_sess_row
810: FROM fnd_sessions
811: WHERE session_id = userenv('sessionid');
812:
813: --
814:

Line 1751: fnd_sessions fs

1747: --{
1748: SELECT period_type
1749: INTO lv_period_type
1750: FROM pay_all_payrolls_f ppf,
1751: fnd_sessions fs
1752: WHERE payroll_id = p_payroll_id
1753: AND fs.effective_date BETWEEN ppf.effective_start_date
1754: AND ppf.effective_end_date
1755: AND fs.session_id = USERENV('sessionid');

Line 1930: fnd_sessions fs

1926:
1927: SELECT period_type
1928: INTO lv_period_type
1929: FROM pay_all_payrolls_f ppf,
1930: fnd_sessions fs
1931: WHERE payroll_id = p_payroll_id
1932: AND fs.effective_date BETWEEN ppf.effective_start_date
1933: AND ppf.effective_end_date
1934: AND fs.session_id = USERENV('sessionid');