APPS.PAY_MX_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 249: FROM pay_payrolls_f

245: RETURN NUMBER IS
246:
247: CURSOR c_period_type( cp_payroll_id NUMBER ) IS
248: SELECT period_type
249: FROM pay_payrolls_f
250: WHERE payroll_id = cp_payroll_id;
251:
252: -- local constants
253:

Line 391: FROM pay_payrolls_f PPF,

387: hr_utility.trace(' v_period_hours is TRUE');
388:
389: SELECT TPT.number_per_fiscal_year
390: INTO v_periods_per_fiscal_yr
391: FROM pay_payrolls_f PPF,
392: per_time_period_types TPT,
393: fnd_sessions fs
394: WHERE PPF.payroll_id = p_payroll
395: AND fs.session_id = USERENV('SESSIONID')

Line 415: FROM pay_payrolls_f PRL,

411: hr_utility.trace(' v_pay_basis = PERIOD');
412:
413: SELECT TPT.number_per_fiscal_year
414: INTO v_annualizing_factor
415: FROM pay_payrolls_f PRL,
416: per_time_period_types TPT,
417: fnd_sessions fs
418: WHERE TPT.period_type = PRL.period_type
419: and fs.session_id = USERENV('SESSIONID')

Line 473: FROM pay_payrolls_f PRL,

469: 'type of the payroll');
470:
471: SELECT TPT.number_per_fiscal_year
472: INTO v_annualizing_factor
473: FROM pay_payrolls_f PRL,
474: per_time_period_types TPT,
475: fnd_sessions fs
476: WHERE TPT.period_type = PRL.period_type
477: AND fs.session_id = USERENV('SESSIONID')

Line 550: FROM pay_payrolls_f ppf,

546: hr_utility.trace('v_period_hours = TRUE');
547:
548: SELECT TPT.number_per_fiscal_year
549: INTO v_periods_per_fiscal_yr
550: FROM pay_payrolls_f ppf,
551: per_time_period_types tpt,
552: fnd_sessions fs
553: WHERE ppf.payroll_id = p_payroll
554: AND fs.session_id = USERENV('SESSIONID')