eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_US_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 1211: FROM pay_payrolls_f PRL,

1207: hr_utility.set_location('calculate_period_earnings', 40);
1208:
1209: SELECT TPT.number_per_fiscal_year
1210: INTO v_pay_periods_per_year
1211: FROM pay_payrolls_f PRL,
1212: per_time_period_types TPT
1213: WHERE TPT.period_type = PRL.period_type
1214: AND p_period_end between PRL.effective_start_date
1215: and PRL.effective_end_date

Line 2479: from pay_payrolls_f PPF,

2475: hr_utility.trace(' v_period_hours is TRUE');
2476:
2477: select TPT.number_per_fiscal_year
2478: into v_periods_per_fiscal_yr
2479: from pay_payrolls_f PPF,
2480: per_time_period_types TPT,
2481: fnd_sessions fs
2482: where PPF.payroll_id = p_payroll
2483: and fs.session_id = USERENV('SESSIONID')

Line 2501: FROM pay_payrolls_f PRL,

2497: hr_utility.trace(' v_pay_basis = PERIOD');
2498:
2499: SELECT TPT.number_per_fiscal_year
2500: INTO v_annualizing_factor
2501: FROM pay_payrolls_f PRL,
2502: per_time_period_types TPT,
2503: fnd_sessions fs
2504: WHERE TPT.period_type = PRL.period_type
2505: and fs.session_id = USERENV('SESSIONID')

Line 2555: FROM pay_payrolls_f PRL,

2551: hr_utility.trace('Get annuallizing factor from period type of the payroll');
2552:
2553: SELECT TPT.number_per_fiscal_year
2554: INTO v_annualizing_factor
2555: FROM pay_payrolls_f PRL,
2556: per_time_period_types TPT,
2557: fnd_sessions fs
2558: WHERE TPT.period_type = PRL.period_type
2559: and fs.session_id = USERENV('SESSIONID')

Line 2653: from pay_payrolls_f PPF,

2649: hr_utility.trace('v_period_hours = TRUE');
2650:
2651: select TPT.number_per_fiscal_year
2652: into v_periods_per_fiscal_yr
2653: from pay_payrolls_f PPF,
2654: per_time_period_types TPT,
2655: fnd_sessions fs
2656: where PPF.payroll_id = p_payroll
2657: and fs.session_id = USERENV('SESSIONID')

Line 2785: from pay_payrolls_f ppf

2781:
2782: begin
2783: select nvl(ppf.prl_information2,'NOT ENTERED')
2784: into v_calc_type
2785: from pay_payrolls_f ppf
2786: where payroll_id = p_payroll_id
2787: and v_stnd_start_date between ppf.effective_start_date
2788: and ppf.effective_end_Date;
2789: exception

Line 4246: FROM pay_payrolls_f PPF,

4242: --
4243: hr_utility.set_location('Dedn_Freq_Factor', 15);
4244: SELECT TPT.number_per_fiscal_year
4245: INTO v_pay_period_num_per_fy
4246: FROM pay_payrolls_f PPF,
4247: per_time_period_types TPT
4248: WHERE TPT.period_type = PPF.period_type
4249: AND p_date_earned BETWEEN PPF.effective_start_date
4250: AND PPF.effective_end_date

Line 4326: pay_payrolls_f PPF

4322: hr_utility.set_location('Dedn_Freq_Factor', 45);
4323: SELECT TPT.number_per_fiscal_year
4324: INTO v_pay_period_num_per_fy
4325: FROM per_time_period_types TPT,
4326: pay_payrolls_f PPF
4327: WHERE TPT.period_type = PPF.period_type
4328: AND p_date_earned BETWEEN PPF.effective_start_date
4329: AND PPF.effective_end_date
4330: AND PPF.payroll_id = p_payroll_id;

Line 4345: FROM pay_payrolls_f PPF,

4341: --
4342: hr_utility.set_location('Dedn_Freq_Factor', 55);
4343: SELECT TPT.number_per_fiscal_year
4344: INTO v_pay_period_num_per_fy
4345: FROM pay_payrolls_f PPF,
4346: per_time_period_types TPT
4347: WHERE TPT.period_type = PPF.period_type
4348: AND PPF.payroll_id = p_payroll_id
4349: AND p_date_earned BETWEEN PPF.effective_start_date