APPS.HR_CA_FF_UDFS dependencies on PAY_PAYROLLS_F

Line 856: FROM pay_payrolls_f PRL,

852:
853: hr_utility.set_location('calculate_period_earnings', 40);
854: SELECT TPT.number_per_fiscal_year
855: INTO v_pay_periods_per_year
856: FROM pay_payrolls_f PRL,
857: per_time_period_types TPT
858: WHERE TPT.period_type = PRL.period_type
859: AND p_period_end between PRL.effective_start_date
860: and PRL.effective_end_date

Line 2142: from pay_payrolls_f PPF,

2138: IF v_period_hours THEN
2139:
2140: select TPT.number_per_fiscal_year
2141: into v_periods_per_fiscal_yr
2142: from pay_payrolls_f PPF,
2143: per_time_period_types TPT,
2144: fnd_sessions fs
2145: where PPF.payroll_id = p_payroll
2146: and fs.session_id = USERENV('SESSIONID')

Line 2165: FROM pay_payrolls_f PRL,

2161: hr_utility.set_location('Get_Annualizing_Factor', 25);
2162:
2163: SELECT TPT.number_per_fiscal_year
2164: INTO v_annualizing_factor
2165: FROM pay_payrolls_f PRL,
2166: per_time_period_types TPT,
2167: fnd_sessions fs
2168: WHERE TPT.period_type = PRL.period_type
2169: and fs.session_id = USERENV('SESSIONID')

Line 2218: FROM pay_payrolls_f PRL,

2214: hr_utility.set_location('Get_Annualizing_Factor', 20);
2215:
2216: SELECT TPT.number_per_fiscal_year
2217: INTO v_annualizing_factor
2218: FROM pay_payrolls_f PRL,
2219: per_time_period_types TPT,
2220: fnd_sessions fs
2221: WHERE TPT.period_type = PRL.period_type
2222: and fs.session_id = USERENV('SESSIONID')

Line 2331: from pay_payrolls_f PPF,

2327: IF v_period_hours THEN
2328:
2329: select TPT.number_per_fiscal_year
2330: into v_periods_per_fiscal_yr
2331: from pay_payrolls_f PPF,
2332: per_time_period_types TPT,
2333: fnd_sessions fs
2334: where PPF.payroll_id = p_payroll
2335: and fs.session_id = USERENV('SESSIONID')

Line 2770: pay_payrolls_f PRL

2766:
2767: SELECT TPT.number_per_fiscal_year
2768: INTO v_number_per_fy
2769: FROM per_time_period_types TPT,
2770: pay_payrolls_f PRL
2771: WHERE TPT.period_type = PRL.period_type
2772: AND PRL.business_group_id + 0 = p_bg_id
2773: AND PRL.payroll_id = p_payroll_id;
2774: --

Line 3842: pay_payrolls_f PPF

3838: hr_utility.set_location('Dedn_Freq_Factor', 45);
3839: SELECT TPT.number_per_fiscal_year
3840: INTO v_pay_period_num_per_fy
3841: FROM per_time_period_types TPT,
3842: pay_payrolls_f PPF
3843: WHERE TPT.period_type = PPF.period_type
3844: AND p_date_earned
3845: BETWEEN PPF.effective_start_date
3846: AND PPF.effective_end_date

Line 3862: FROM pay_payrolls_f PPF,

3858: --
3859: hr_utility.set_location('Dedn_Freq_Factor', 55);
3860: SELECT TPT.number_per_fiscal_year
3861: INTO v_pay_period_num_per_fy
3862: FROM pay_payrolls_f PPF,
3863: per_time_period_types TPT
3864: WHERE TPT.period_type = PPF.period_type
3865: AND PPF.payroll_id = p_payroll_id
3866: AND p_date_earned