APPS.PAY_CORE_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 573: FROM pay_payrolls_f PPF,

569: hr_utility.trace(' v_period_hours is TRUE');
570:
571: SELECT TPT.number_per_fiscal_year
572: INTO v_periods_per_fiscal_yr
573: FROM pay_payrolls_f PPF,
574: per_time_period_types TPT,
575: fnd_sessions fs
576: WHERE PPF.payroll_id = p_payroll_id
577: AND fs.session_id = USERENV('SESSIONID')

Line 597: FROM pay_payrolls_f PRL,

593: hr_utility.trace(' v_pay_basis = PERIOD');
594:
595: SELECT TPT.number_per_fiscal_year
596: INTO v_annualizing_factor
597: FROM pay_payrolls_f PRL,
598: per_time_period_types TPT,
599: fnd_sessions fs
600: WHERE TPT.period_type = PRL.period_type
601: and fs.session_id = USERENV('SESSIONID')

Line 657: FROM pay_payrolls_f PRL,

653: 'type of the payroll');
654:
655: SELECT TPT.number_per_fiscal_year
656: INTO v_annualizing_factor
657: FROM pay_payrolls_f PRL,
658: per_time_period_types TPT,
659: fnd_sessions fs
660: WHERE TPT.period_type = PRL.period_type
661: AND fs.session_id = USERENV('SESSIONID')

Line 710: FROM pay_payrolls_f ppf,

706: hr_utility.trace('v_period_hours = TRUE');
707:
708: SELECT TPT.number_per_fiscal_year
709: INTO v_periods_per_fiscal_yr
710: FROM pay_payrolls_f ppf,
711: per_time_period_types tpt,
712: fnd_sessions fs
713: WHERE ppf.payroll_id = p_payroll_id
714: AND fs.session_id = USERENV('SESSIONID')

Line 924: from pay_payrolls_f ppf

920:
921: begin
922: select nvl(ppf.prl_information2,'NOT ENTERED')
923: into v_calc_type
924: from pay_payrolls_f ppf
925: where payroll_id = p_payroll_id
926: and v_stnd_start_date between ppf.effective_start_date
927: and ppf.effective_end_Date;
928: exception

Line 1962: FROM pay_payrolls_f PRL,

1958: hr_utility.set_location('calculate_period_earnings', 40);
1959:
1960: SELECT TPT.number_per_fiscal_year
1961: INTO v_pay_periods_per_year
1962: FROM pay_payrolls_f PRL,
1963: per_time_period_types TPT
1964: WHERE TPT.period_type = PRL.period_type
1965: AND p_period_end between PRL.effective_start_date
1966: and PRL.effective_end_date