DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on FND_SESSIONS

Line 575: fnd_sessions fs

571: SELECT TPT.number_per_fiscal_year
572: INTO v_periods_per_fiscal_yr
573: FROM pay_payrolls_f PPF,
574: per_time_period_types TPT,
575: fnd_sessions fs
576: WHERE PPF.payroll_id = p_payroll_id
577: AND fs.session_id = USERENV('SESSIONID')
578: AND fs.effective_date between PPF.effective_start_date
579: and PPF.effective_end_date

Line 599: fnd_sessions fs

595: SELECT TPT.number_per_fiscal_year
596: INTO v_annualizing_factor
597: FROM pay_payrolls_f PRL,
598: per_time_period_types TPT,
599: fnd_sessions fs
600: WHERE TPT.period_type = PRL.period_type
601: and fs.session_id = USERENV('SESSIONID')
602: and fs.effective_date BETWEEN PRL.effective_start_date
603: AND PRL.effective_end_date

Line 659: fnd_sessions fs

655: SELECT TPT.number_per_fiscal_year
656: INTO v_annualizing_factor
657: FROM pay_payrolls_f PRL,
658: per_time_period_types TPT,
659: fnd_sessions fs
660: WHERE TPT.period_type = PRL.period_type
661: AND fs.session_id = USERENV('SESSIONID')
662: AND fs.effective_date BETWEEN PRL.effective_start_date
663: AND PRL.effective_end_date

Line 712: fnd_sessions fs

708: SELECT TPT.number_per_fiscal_year
709: INTO v_periods_per_fiscal_yr
710: FROM pay_payrolls_f ppf,
711: per_time_period_types tpt,
712: fnd_sessions fs
713: WHERE ppf.payroll_id = p_payroll_id
714: AND fs.session_id = USERENV('SESSIONID')
715: AND fs.effective_date BETWEEN ppf.effective_start_date
716: AND ppf.effective_end_date