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 1220: FROM pay_payrolls_f PRL,

1216: hr_utility.set_location('calculate_period_earnings', 40);
1217:
1218: SELECT TPT.number_per_fiscal_year
1219: INTO v_pay_periods_per_year
1220: FROM pay_payrolls_f PRL,
1221: per_time_period_types TPT
1222: WHERE TPT.period_type = PRL.period_type
1223: AND p_period_end between PRL.effective_start_date
1224: and PRL.effective_end_date

Line 2488: from pay_payrolls_f PPF,

2484: hr_utility.trace(' v_period_hours is TRUE');
2485:
2486: select TPT.number_per_fiscal_year
2487: into v_periods_per_fiscal_yr
2488: from pay_payrolls_f PPF,
2489: per_time_period_types TPT,
2490: fnd_sessions fs
2491: where PPF.payroll_id = p_payroll
2492: and fs.session_id = USERENV('SESSIONID')

Line 2510: FROM pay_payrolls_f PRL,

2506: hr_utility.trace(' v_pay_basis = PERIOD');
2507:
2508: SELECT TPT.number_per_fiscal_year
2509: INTO v_annualizing_factor
2510: FROM pay_payrolls_f PRL,
2511: per_time_period_types TPT,
2512: fnd_sessions fs
2513: WHERE TPT.period_type = PRL.period_type
2514: and fs.session_id = USERENV('SESSIONID')

Line 2564: FROM pay_payrolls_f PRL,

2560: hr_utility.trace('Get annuallizing factor from period type of the payroll');
2561:
2562: SELECT TPT.number_per_fiscal_year
2563: INTO v_annualizing_factor
2564: FROM pay_payrolls_f PRL,
2565: per_time_period_types TPT,
2566: fnd_sessions fs
2567: WHERE TPT.period_type = PRL.period_type
2568: and fs.session_id = USERENV('SESSIONID')

Line 2662: from pay_payrolls_f PPF,

2658: hr_utility.trace('v_period_hours = TRUE');
2659:
2660: select TPT.number_per_fiscal_year
2661: into v_periods_per_fiscal_yr
2662: from pay_payrolls_f PPF,
2663: per_time_period_types TPT,
2664: fnd_sessions fs
2665: where PPF.payroll_id = p_payroll
2666: and fs.session_id = USERENV('SESSIONID')

Line 2794: from pay_payrolls_f ppf

2790:
2791: begin
2792: select nvl(ppf.prl_information2,'NOT ENTERED')
2793: into v_calc_type
2794: from pay_payrolls_f ppf
2795: where payroll_id = p_payroll_id
2796: and v_stnd_start_date between ppf.effective_start_date
2797: and ppf.effective_end_Date;
2798: exception

Line 4255: FROM pay_payrolls_f PPF,

4251: --
4252: hr_utility.set_location('Dedn_Freq_Factor', 15);
4253: SELECT TPT.number_per_fiscal_year
4254: INTO v_pay_period_num_per_fy
4255: FROM pay_payrolls_f PPF,
4256: per_time_period_types TPT
4257: WHERE TPT.period_type = PPF.period_type
4258: AND p_date_earned BETWEEN PPF.effective_start_date
4259: AND PPF.effective_end_date

Line 4335: pay_payrolls_f PPF

4331: hr_utility.set_location('Dedn_Freq_Factor', 45);
4332: SELECT TPT.number_per_fiscal_year
4333: INTO v_pay_period_num_per_fy
4334: FROM per_time_period_types TPT,
4335: pay_payrolls_f PPF
4336: WHERE TPT.period_type = PPF.period_type
4337: AND p_date_earned BETWEEN PPF.effective_start_date
4338: AND PPF.effective_end_date
4339: AND PPF.payroll_id = p_payroll_id;

Line 4354: FROM pay_payrolls_f PPF,

4350: --
4351: hr_utility.set_location('Dedn_Freq_Factor', 55);
4352: SELECT TPT.number_per_fiscal_year
4353: INTO v_pay_period_num_per_fy
4354: FROM pay_payrolls_f PPF,
4355: per_time_period_types TPT
4356: WHERE TPT.period_type = PPF.period_type
4357: AND PPF.payroll_id = p_payroll_id
4358: AND p_date_earned BETWEEN PPF.effective_start_date