DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on FND_SESSIONS

Line 3141: fnd_sessions fs

3137: select TPT.number_per_fiscal_year
3138: into v_periods_per_fiscal_yr
3139: from pay_payrolls_f PPF,
3140: per_time_period_types TPT,
3141: fnd_sessions fs
3142: where PPF.payroll_id = p_payroll
3143: and fs.session_id = USERENV('SESSIONID')
3144: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
3145: and TPT.period_type = PPF.period_type;

Line 3163: fnd_sessions fs

3159: SELECT TPT.number_per_fiscal_year
3160: INTO v_annualizing_factor
3161: FROM pay_payrolls_f PRL,
3162: per_time_period_types TPT,
3163: fnd_sessions fs
3164: WHERE TPT.period_type = PRL.period_type
3165: and fs.session_id = USERENV('SESSIONID')
3166: and fs.effective_date BETWEEN PRL.effective_start_date
3167: AND PRL.effective_end_date

Line 3217: fnd_sessions fs

3213: SELECT TPT.number_per_fiscal_year
3214: INTO v_annualizing_factor
3215: FROM pay_payrolls_f PRL,
3216: per_time_period_types TPT,
3217: fnd_sessions fs
3218: WHERE TPT.period_type = PRL.period_type
3219: and fs.session_id = USERENV('SESSIONID')
3220: and fs.effective_date BETWEEN PRL.effective_start_date
3221: AND PRL.effective_end_date

Line 3315: fnd_sessions fs

3311: select TPT.number_per_fiscal_year
3312: into v_periods_per_fiscal_yr
3313: from pay_payrolls_f PPF,
3314: per_time_period_types TPT,
3315: fnd_sessions fs
3316: where PPF.payroll_id = p_payroll
3317: and fs.session_id = USERENV('SESSIONID')
3318: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date
3319: and TPT.period_type = PPF.period_type;