[Home] [Help]
3136:
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
3158:
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
3212:
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
3230: hr_utility.trace('Not hourly - an actual time period type');
3231:
3232: BEGIN
3233:
3234: hr_utility.trace(' selecting from per_time_period_types');
3235:
3236: SELECT PT.number_per_fiscal_year
3237: INTO v_annualizing_factor
3238: FROM per_time_period_types PT
3234: hr_utility.trace(' selecting from per_time_period_types');
3235:
3236: SELECT PT.number_per_fiscal_year
3237: INTO v_annualizing_factor
3238: FROM per_time_period_types PT
3239: WHERE UPPER(PT.period_type) = UPPER(p_freq);
3240:
3241: hr_utility.trace('v_annualizing_factor ='||to_number(v_annualizing_factor));
3242:
3310:
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