232: RETURN NUMBER IS
233:
234: CURSOR c_period_type( cp_payroll_id NUMBER ) IS
235: SELECT period_type
236: FROM pay_payrolls_f
237: WHERE payroll_id = cp_payroll_id;
238:
239: -- local constants
240:
374: hr_utility.trace(' v_period_hours is TRUE');
375:
376: SELECT TPT.number_per_fiscal_year
377: INTO v_periods_per_fiscal_yr
378: FROM pay_payrolls_f PPF,
379: per_time_period_types TPT,
380: fnd_sessions fs
381: WHERE PPF.payroll_id = p_payroll
382: AND fs.session_id = USERENV('SESSIONID')
398: hr_utility.trace(' v_pay_basis = PERIOD');
399:
400: SELECT TPT.number_per_fiscal_year
401: INTO v_annualizing_factor
402: FROM pay_payrolls_f PRL,
403: per_time_period_types TPT,
404: fnd_sessions fs
405: WHERE TPT.period_type = PRL.period_type
406: and fs.session_id = USERENV('SESSIONID')
456: 'type of the payroll');
457:
458: SELECT TPT.number_per_fiscal_year
459: INTO v_annualizing_factor
460: FROM pay_payrolls_f PRL,
461: per_time_period_types TPT,
462: fnd_sessions fs
463: WHERE TPT.period_type = PRL.period_type
464: AND fs.session_id = USERENV('SESSIONID')
533: hr_utility.trace('v_period_hours = TRUE');
534:
535: SELECT TPT.number_per_fiscal_year
536: INTO v_periods_per_fiscal_yr
537: FROM pay_payrolls_f ppf,
538: per_time_period_types tpt,
539: fnd_sessions fs
540: WHERE ppf.payroll_id = p_payroll
541: AND fs.session_id = USERENV('SESSIONID')