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_CA_FF_UDFS dependencies on PER_TIME_PERIOD_TYPES

Line 842: -- --> Per_time_period_types.number_per_fiscal_year.

838: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
839: --
840: -- In either case, need to find the payroll period type, let's do it upfront:
841: -- Assignment.payroll_id --> Payroll.period_type
842: -- --> Per_time_period_types.number_per_fiscal_year.
843: -- Actually, the number per fiscal year could be found in more than one way:
844: -- Could also go to per_time_period_rules, but would mean decoding the
845: -- payroll period type to an appropriate proc_period_type code.
846: --

Line 857: per_time_period_types TPT

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
861: AND PRL.payroll_id = p_payroll_id

Line 2143: per_time_period_types TPT,

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')
2147: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date

Line 2166: per_time_period_types TPT,

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')
2170: and fs.effective_date BETWEEN PRL.effective_start_date

Line 2219: per_time_period_types TPT,

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')
2223: and fs.effective_date BETWEEN PRL.effective_start_date

Line 2240: FROM per_time_period_types PT

2236: hr_utility.set_location('Get_Annualizing_Factor',24);
2237:
2238: SELECT PT.number_per_fiscal_year
2239: INTO v_annualizing_factor
2240: FROM per_time_period_types PT
2241: WHERE UPPER(PT.period_type) = UPPER(p_freq);
2242:
2243: /* changed for bug 5155854
2244: decode(UPPER(p_freq),'W','WEEK','M','MONTH','D','DAY','Y','YEAR','H','HOUR');

Line 2332: per_time_period_types TPT,

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')
2336: and fs.effective_date between PPF.effective_start_date and PPF.effective_end_date

Line 2769: FROM per_time_period_types TPT,

2765: AND payroll_id = p_payroll_id;
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;

Line 3835: FROM per_time_period_types TPT

3831: --
3832: hr_utility.set_location('Dedn_Freq_Factor', 40);
3833: SELECT number_per_fiscal_year
3834: INTO v_ele_period_num_per_fy
3835: FROM per_time_period_types TPT
3836: WHERE UPPER(period_type) = UPPER(p_ele_period_type);
3837: --
3838: hr_utility.set_location('Dedn_Freq_Factor', 45);
3839: SELECT TPT.number_per_fiscal_year

Line 3841: FROM per_time_period_types TPT,

3837: --
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

Line 3856: FROM per_time_period_types TPT

3852: --
3853: hr_utility.set_location('Dedn_Freq_Factor', 50);
3854: SELECT number_per_fiscal_year
3855: INTO v_ele_period_num_per_fy
3856: FROM per_time_period_types TPT
3857: WHERE UPPER(period_type) = UPPER(p_ele_period_type);
3858: --
3859: hr_utility.set_location('Dedn_Freq_Factor', 55);
3860: SELECT TPT.number_per_fiscal_year

Line 3863: per_time_period_types TPT

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
3867: BETWEEN PPF.effective_start_date