APPS.HR_CA_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 862: FROM pay_payrolls_f PRL,

858:
859: hr_utility.set_location('calculate_period_earnings', 40);
860: SELECT TPT.number_per_fiscal_year
861: INTO v_pay_periods_per_year
862: FROM pay_payrolls_f PRL,
863: per_time_period_types TPT
864: WHERE TPT.period_type = PRL.period_type
865: AND p_period_end between PRL.effective_start_date
866: and PRL.effective_end_date

Line 2179: from pay_payrolls_f PPF,

2175: IF v_period_hours THEN
2176:
2177: select TPT.number_per_fiscal_year
2178: into v_periods_per_fiscal_yr
2179: from pay_payrolls_f PPF,
2180: per_time_period_types TPT,
2181: fnd_sessions fs
2182: where PPF.payroll_id = p_payroll
2183: and fs.session_id = USERENV('SESSIONID')

Line 2202: FROM pay_payrolls_f PRL,

2198: hr_utility.set_location('Get_Annualizing_Factor', 25);
2199:
2200: SELECT TPT.number_per_fiscal_year
2201: INTO v_annualizing_factor
2202: FROM pay_payrolls_f PRL,
2203: per_time_period_types TPT,
2204: fnd_sessions fs
2205: WHERE TPT.period_type = PRL.period_type
2206: and fs.session_id = USERENV('SESSIONID')

Line 2255: FROM pay_payrolls_f PRL,

2251: hr_utility.set_location('Get_Annualizing_Factor', 20);
2252:
2253: SELECT TPT.number_per_fiscal_year
2254: INTO v_annualizing_factor
2255: FROM pay_payrolls_f PRL,
2256: per_time_period_types TPT,
2257: fnd_sessions fs
2258: WHERE TPT.period_type = PRL.period_type
2259: and fs.session_id = USERENV('SESSIONID')

Line 2368: from pay_payrolls_f PPF,

2364: IF v_period_hours THEN
2365:
2366: select TPT.number_per_fiscal_year
2367: into v_periods_per_fiscal_yr
2368: from pay_payrolls_f PPF,
2369: per_time_period_types TPT,
2370: fnd_sessions fs
2371: where PPF.payroll_id = p_payroll
2372: and fs.session_id = USERENV('SESSIONID')

Line 2807: pay_payrolls_f PRL

2803:
2804: SELECT TPT.number_per_fiscal_year
2805: INTO v_number_per_fy
2806: FROM per_time_period_types TPT,
2807: pay_payrolls_f PRL
2808: WHERE TPT.period_type = PRL.period_type
2809: AND PRL.business_group_id + 0 = p_bg_id
2810: AND PRL.payroll_id = p_payroll_id;
2811: --

Line 3879: pay_payrolls_f PPF

3875: hr_utility.set_location('Dedn_Freq_Factor', 45);
3876: SELECT TPT.number_per_fiscal_year
3877: INTO v_pay_period_num_per_fy
3878: FROM per_time_period_types TPT,
3879: pay_payrolls_f PPF
3880: WHERE TPT.period_type = PPF.period_type
3881: AND p_date_earned
3882: BETWEEN PPF.effective_start_date
3883: AND PPF.effective_end_date

Line 3899: FROM pay_payrolls_f PPF,

3895: --
3896: hr_utility.set_location('Dedn_Freq_Factor', 55);
3897: SELECT TPT.number_per_fiscal_year
3898: INTO v_pay_period_num_per_fy
3899: FROM pay_payrolls_f PPF,
3900: per_time_period_types TPT
3901: WHERE TPT.period_type = PPF.period_type
3902: AND PPF.payroll_id = p_payroll_id
3903: AND p_date_earned