DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on FND_SESSIONS

Line 298: fnd_sessions fs

294: SELECT TPT.number_per_fiscal_year
295: INTO v_periods_per_fiscal_yr
296: FROM pay_payrolls_f PPF,
297: per_time_period_types TPT,
298: fnd_sessions fs
299: WHERE PPF.payroll_id = p_payroll_id
300: AND fs.session_id = USERENV('SESSIONID')
301: AND fs.effective_date between PPF.effective_start_date
302: and PPF.effective_end_date

Line 322: fnd_sessions fs

318: SELECT TPT.number_per_fiscal_year
319: INTO v_annualizing_factor
320: FROM pay_payrolls_f PRL,
321: per_time_period_types TPT,
322: fnd_sessions fs
323: WHERE TPT.period_type = PRL.period_type
324: and fs.session_id = USERENV('SESSIONID')
325: and fs.effective_date BETWEEN PRL.effective_start_date
326: AND PRL.effective_end_date

Line 382: fnd_sessions fs

378: SELECT TPT.number_per_fiscal_year
379: INTO v_annualizing_factor
380: FROM pay_payrolls_f PRL,
381: per_time_period_types TPT,
382: fnd_sessions fs
383: WHERE TPT.period_type = PRL.period_type
384: AND fs.session_id = USERENV('SESSIONID')
385: AND fs.effective_date BETWEEN PRL.effective_start_date
386: AND PRL.effective_end_date

Line 435: fnd_sessions fs

431: SELECT TPT.number_per_fiscal_year
432: INTO v_periods_per_fiscal_yr
433: FROM pay_payrolls_f ppf,
434: per_time_period_types tpt,
435: fnd_sessions fs
436: WHERE ppf.payroll_id = p_payroll_id
437: AND fs.session_id = USERENV('SESSIONID')
438: AND fs.effective_date BETWEEN ppf.effective_start_date
439: AND ppf.effective_end_date