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 PER_TIME_PERIOD_TYPES

Line 1195: -- --> Per_time_period_types.number_per_fiscal_year.

1191: -- pre-defined earnings, REGULAR_WAGES_RATE) pay period earnings.
1192: --
1193: -- In either case, need to find the payroll period type, let's do it upfront:
1194: -- Assignment.payroll_id --> Payroll.period_type
1195: -- --> Per_time_period_types.number_per_fiscal_year.
1196: -- Actually, the number per fiscal year could be found in more than one way:
1197: -- Could also go to per_time_period_rules, but would mean decoding the
1198: -- payroll period type to an appropriate proc_period_type code.
1199: --

Line 1212: per_time_period_types TPT

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

Line 2480: per_time_period_types TPT,

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

Line 2502: per_time_period_types TPT,

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

Line 2556: per_time_period_types TPT,

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

Line 2574: hr_utility.trace(' selecting from per_time_period_types');

2570: hr_utility.trace('Not hourly - an actual time period type');
2571:
2572: BEGIN
2573:
2574: hr_utility.trace(' selecting from per_time_period_types');
2575:
2576: SELECT PT.number_per_fiscal_year
2577: INTO v_annualizing_factor
2578: FROM per_time_period_types PT

Line 2578: FROM per_time_period_types PT

2574: hr_utility.trace(' selecting from per_time_period_types');
2575:
2576: SELECT PT.number_per_fiscal_year
2577: INTO v_annualizing_factor
2578: FROM per_time_period_types PT
2579: WHERE UPPER(PT.period_type) = UPPER(p_freq);
2580:
2581: hr_utility.trace('v_annualizing_factor ='||to_number(v_annualizing_factor));
2582:

Line 2654: per_time_period_types TPT,

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

Line 4247: per_time_period_types TPT

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
4251: AND PPF.payroll_id = p_payroll_id;

Line 4319: FROM per_time_period_types TPT

4315: --
4316: hr_utility.set_location('Dedn_Freq_Factor', 40);
4317: SELECT number_per_fiscal_year
4318: INTO v_ele_period_num_per_fy
4319: FROM per_time_period_types TPT
4320: WHERE UPPER(period_type) = UPPER(p_ele_period_type);
4321: --
4322: hr_utility.set_location('Dedn_Freq_Factor', 45);
4323: SELECT TPT.number_per_fiscal_year

Line 4325: FROM per_time_period_types TPT,

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

Line 4339: FROM per_time_period_types TPT

4335: --
4336: hr_utility.set_location('Dedn_Freq_Factor', 50);
4337: SELECT number_per_fiscal_year
4338: INTO v_ele_period_num_per_fy
4339: FROM per_time_period_types TPT
4340: WHERE UPPER(period_type) = UPPER(p_ele_period_type);
4341: --
4342: hr_utility.set_location('Dedn_Freq_Factor', 55);
4343: SELECT TPT.number_per_fiscal_year

Line 4346: per_time_period_types TPT

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
4350: AND PPF.effective_end_date;