APPS.PAY_CORE_FF_UDFS dependencies on PER_TIME_PERIOD_TYPES

Line 297: per_time_period_types TPT,

293:
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

Line 321: per_time_period_types TPT,

317:
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

Line 381: per_time_period_types TPT,

377:
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

Line 434: per_time_period_types tpt,

430:
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

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

471: hr_utility.trace('Not hourly - an actual time period type');
472:
473: BEGIN
474:
475: hr_utility.trace(' selecting from per_time_period_types');
476:
477: SELECT PT.number_per_fiscal_year
478: INTO v_annualizing_factor
479: FROM per_time_period_types PT

Line 479: FROM per_time_period_types PT

475: hr_utility.trace(' selecting from per_time_period_types');
476:
477: SELECT PT.number_per_fiscal_year
478: INTO v_annualizing_factor
479: FROM per_time_period_types PT
480: WHERE UPPER(PT.period_type) = UPPER(p_freq);
481:
482: hr_utility.trace('v_annualizing_factor ='||
483: to_number(v_annualizing_factor));

Line 1567: -- --> Per_time_period_types.number_per_fiscal_year.

1563: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
1564: --
1565: -- In either case, need to find the payroll period type, let's do it upfront:
1566: -- Assignment.payroll_id --> Payroll.period_type
1567: -- --> Per_time_period_types.number_per_fiscal_year.
1568: -- Actually, the number per fiscal year could be found in more than one way:
1569: -- Could also go to per_time_period_rules, but would mean decoding the
1570: -- payroll period type to an appropriate proc_period_type code.
1571: --

Line 1584: per_time_period_types TPT

1580:
1581: SELECT TPT.number_per_fiscal_year
1582: INTO v_pay_periods_per_year
1583: FROM pay_payrolls_f PRL,
1584: per_time_period_types TPT
1585: WHERE TPT.period_type = PRL.period_type
1586: AND p_period_end between PRL.effective_start_date
1587: and PRL.effective_end_date
1588: AND PRL.payroll_id = p_payroll_id