APPS.PAY_CORE_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 296: FROM pay_payrolls_f PPF,

292: hr_utility.trace(' v_period_hours is TRUE');
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')

Line 320: FROM pay_payrolls_f PRL,

316: hr_utility.trace(' v_pay_basis = PERIOD');
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')

Line 380: FROM pay_payrolls_f PRL,

376: 'type of the payroll');
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')

Line 433: FROM pay_payrolls_f ppf,

429: hr_utility.trace('v_period_hours = TRUE');
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')

Line 648: from pay_payrolls_f ppf

644:
645: begin
646: select nvl(ppf.prl_information2,'NOT ENTERED')
647: into v_calc_type
648: from pay_payrolls_f ppf
649: where payroll_id = p_payroll_id
650: and v_stnd_start_date between ppf.effective_start_date
651: and ppf.effective_end_Date;
652: exception

Line 1583: FROM pay_payrolls_f PRL,

1579: hr_utility.set_location('calculate_period_earnings', 40);
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