APPS.PAY_MX_FF_UDFS dependencies on PER_TIME_PERIOD_TYPES

Line 379: per_time_period_types TPT,

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')
383: AND fs.effective_date between PPF.effective_start_date

Line 403: per_time_period_types TPT,

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')
407: and fs.effective_date BETWEEN PRL.effective_start_date

Line 461: per_time_period_types TPT,

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')
465: AND fs.effective_date BETWEEN PRL.effective_start_date

Line 538: per_time_period_types tpt,

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')
542: AND fs.effective_date BETWEEN ppf.effective_start_date

Line 579: hr_utility.trace(' selecting from per_time_period_types');

575: hr_utility.trace('Not hourly - an actual time period type');
576:
577: BEGIN
578:
579: hr_utility.trace(' selecting from per_time_period_types');
580:
581: SELECT PT.number_per_fiscal_year
582: INTO v_annualizing_factor
583: FROM per_time_period_types PT

Line 583: FROM per_time_period_types PT

579: hr_utility.trace(' selecting from per_time_period_types');
580:
581: SELECT PT.number_per_fiscal_year
582: INTO v_annualizing_factor
583: FROM per_time_period_types PT
584: WHERE UPPER(PT.period_type) = UPPER(p_freq);
585:
586: hr_utility.trace('v_annualizing_factor ='||
587: to_number(v_annualizing_factor));