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_INPUT_VALUES_F

Line 1074: FROM pay_input_values_f IPV,

1070:
1071: begin
1072: SELECT IPV.input_value_id
1073: INTO v_inpval_id
1074: FROM pay_input_values_f IPV,
1075: pay_element_types_f ELT
1076: WHERE ELT.element_name = 'Regular Wages'
1077: and p_period_start BETWEEN ELT.effective_start_date
1078: AND ELT.effective_end_date

Line 1108: FROM pay_input_values_f IPV,

1104: hr_utility.trace('In RATE CODE');
1105:
1106: SELECT IPV.input_value_id
1107: INTO v_inpval_id
1108: FROM pay_input_values_f IPV,
1109: pay_element_types_f ELT
1110: WHERE ELT.element_name = 'Regular Wages'
1111: and p_period_start BETWEEN ELT.effective_start_date
1112: AND ELT.effective_end_date

Line 1143: FROM pay_input_values_f IPV,

1139: hr_utility.trace('in MONTHLY SALARY');
1140:
1141: SELECT IPV.input_value_id
1142: INTO v_inpval_id
1143: FROM pay_input_values_f IPV,
1144: pay_element_types_f ELT
1145: WHERE ELT.element_name = 'Regular Salary'
1146: and p_period_start BETWEEN ELT.effective_start_date
1147: AND ELT.effective_end_date

Line 3213: pay_input_values_f IPV

3209: SELECT RRV.result_value
3210: INTO v_dedn_proc
3211: FROM pay_run_result_values RRV,
3212: pay_run_results PRR,
3213: pay_input_values_f IPV
3214: WHERE PRR.assignment_action_id = p_assact_id
3215: AND RRV.result_value <> 'A'
3216: AND RRV.run_result_id = PRR.run_result_id
3217: AND IPV.input_value_id = RRV.input_value_id

Line 3313: pay_input_values_f IPV

3309: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3310: INTO sepcheck_flag
3311: FROM pay_element_entry_values_f EEV,
3312: pay_element_entries_f ELE,
3313: pay_input_values_f IPV
3314: WHERE ELE.assignment_id = p_ass_id
3315: AND p_date_earned BETWEEN ELE.effective_start_date
3316: AND ELE.effective_end_date
3317: AND ELE.element_entry_id = EEV.element_entry_id

Line 3353: FROM pay_input_values_f IPV

3349: 'IMPUTED EARNINGS',
3350: 'NON-PAYROLL PAYMENTS')
3351: AND NOT EXISTS
3352: (SELECT 'X'
3353: FROM pay_input_values_f IPV
3354: WHERE IPV.element_type_id = ELT.element_type_id
3355: AND p_date_earned BETWEEN IPV.effective_start_date
3356: and IPV.effective_end_date
3357: AND UPPER(IPV.name) = 'SEPARATE CHECK');

Line 3475: pay_input_values_f IPV,

3471: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3472: EEV.element_entry_id
3473: FROM pay_element_entries_f ELE,
3474: pay_element_entry_values_f EEV,
3475: pay_input_values_f IPV,
3476: pay_element_types_f ELT
3477: WHERE ELE.assignment_id = p_ass_id
3478: AND p_date_earned BETWEEN ELE.effective_start_date
3479: AND ELE.effective_end_date

Line 3499: pay_input_values_f IPV

3495: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3496: FROM pay_element_entry_values_f EEV,
3497: pay_element_entries_f ELE,
3498: pay_element_types_f ELT,
3499: pay_input_values_f IPV
3500: WHERE ELE.assignment_id = p_ass_id
3501: AND p_date_earned BETWEEN ELE.effective_start_date
3502: AND ELE.effective_end_date
3503: AND ELE.element_entry_id = EEV.element_entry_id

Line 3554: pay_input_values_f ipv

3550: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3551: FROM pay_element_links_f pel,
3552: pay_element_entries_f ele,
3553: pay_element_entry_values_f eev,
3554: pay_input_values_f ipv
3555: WHERE pel.element_type_id = v_eletype_id
3556: AND p_date_earned BETWEEN pel.effective_start_date
3557: AND pel.effective_end_date
3558: AND ele.element_link_id = pel.element_link_id

Line 3573: pay_input_values_f ipv

3569: EEV.element_entry_id
3570: FROM pay_element_links_f pel,
3571: pay_element_entries_f ele,
3572: pay_element_entry_values_f eev,
3573: pay_input_values_f ipv
3574: WHERE pel.element_type_id = v_eletype_id
3575: AND p_date_earned BETWEEN pel.effective_start_date
3576: AND pel.effective_end_date
3577: AND ele.element_link_id = pel.element_link_id

Line 3591: pay_input_values_f ipv

3587: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3588: FROM pay_element_links_f pel,
3589: pay_element_entries_f ele,
3590: pay_element_entry_values_f eev,
3591: pay_input_values_f ipv
3592: WHERE pel.element_type_id = v_eletype_id
3593: AND p_date_earned BETWEEN pel.effective_start_date
3594: AND pel.effective_end_date
3595: AND ele.element_link_id = pel.element_link_id

Line 3608: pay_input_values_f IPV,

3604: CURSOR get_grosses IS
3605: SELECT fnd_number.canonical_to_number(RRV.result_value)
3606: FROM pay_run_result_values RRV,
3607: pay_run_results RRS,
3608: pay_input_values_f IPV,
3609: pay_element_types_f ELT
3610: WHERE RRV.input_value_id = IPV.input_value_id
3611: AND RRV.run_result_id = RRS.run_result_id
3612: AND RRS.element_type_id = ELT.element_type_id

Line 3706: pay_input_values_f IPV,

3702: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3703: INTO v_tew_rcode
3704: FROM pay_element_entries_f ELE,
3705: pay_element_entry_values_f EEV,
3706: pay_input_values_f IPV,
3707: pay_element_types_f ELT
3708: WHERE ELE.assignment_id = p_ass_id
3709: AND EEV.element_entry_id = v_entry_id
3710: AND ELE.element_entry_id = EEV.element_entry_id

Line 3751: pay_input_values_f IPV,

3747: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3748: INTO v_use_regwage
3749: FROM pay_element_entries_f ELE,
3750: pay_element_entry_values_f EEV,
3751: pay_input_values_f IPV,
3752: pay_element_types_f ELT
3753: WHERE ELE.assignment_id = p_ass_id
3754: AND p_date_earned BETWEEN ELE.effective_start_date
3755: AND ELE.effective_end_date

Line 3779: pay_input_values_f IPV,

3775: INTO v_regwage_rate,
3776: v_entry_id
3777: FROM pay_element_entries_f ELE,
3778: pay_element_entry_values_f EEV,
3779: pay_input_values_f IPV,
3780: pay_element_types_f ELT
3781: WHERE ELE.assignment_id = p_ass_id
3782: AND p_date_earned BETWEEN ele.effective_start_date
3783: AND ele.effective_end_date

Line 3805: pay_input_values_f IPV,

3801: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3802: INTO v_regwage_rcode
3803: FROM pay_element_entries_f ELE,
3804: pay_element_entry_values_f EEV,
3805: pay_input_values_f IPV,
3806: pay_element_types_f ELT
3807: WHERE ELE.assignment_id = p_ass_id
3808: AND p_date_earned between ELE.effective_start_date
3809: AND ELE.effective_end_date

Line 3841: pay_input_values_f IPV,

3837: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3838: INTO v_use_regsal
3839: FROM pay_element_entries_f ELE,
3840: pay_element_entry_values_f EEV,
3841: pay_input_values_f IPV,
3842: pay_element_types_f ELT
3843: WHERE ELE.assignment_id = p_ass_id
3844: AND p_date_earned BETWEEN ELE.effective_start_date
3845: AND ELE.effective_end_date

Line 3867: pay_input_values_f IPV,

3863: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3864: INTO v_regsal_mosal
3865: FROM pay_element_entries_f ELE,
3866: pay_element_entry_values_f EEV,
3867: pay_input_values_f IPV,
3868: pay_element_types_f ELT
3869: WHERE ELE.assignment_id = p_ass_id
3870: AND p_date_earned BETWEEN ELE.effective_start_date
3871: AND ELE.effective_end_date

Line 3992: pay_input_values_f IPV

3988: INTO v_rate_rcode
3989: FROM pay_element_entry_values_f EEV,
3990: pay_element_entries_f ELE,
3991: pay_element_types_f ELT,
3992: pay_input_values_f IPV
3993: WHERE ELE.assignment_id = p_ass_id
3994: AND ELE.element_entry_id = EEV.element_entry_id
3995: AND p_date_earned BETWEEN EEV.effective_start_date
3996: AND EEV.effective_end_date

Line 4021: pay_input_values_f IPV

4017: INTO v_rate_mult_count
4018: FROM pay_element_entry_values_f EEV,
4019: pay_element_entries_f ELE,
4020: pay_element_types_f ELT,
4021: pay_input_values_f IPV
4022: WHERE ELE.assignment_id = p_ass_id
4023: AND ELE.element_entry_id = EEV.element_entry_id
4024: AND p_date_earned BETWEEN EEV.effective_start_date
4025: AND EEV.effective_end_date

Line 4039: pay_input_values_f IPV

4035: INTO v_rate_multiple
4036: FROM pay_element_entry_values_f EEV,
4037: pay_element_entries_f ELE,
4038: pay_element_types_f ELT,
4039: pay_input_values_f IPV
4040: WHERE ELE.assignment_id = p_ass_id
4041: AND ELE.element_entry_id = EEV.element_entry_id
4042: AND p_date_earned BETWEEN EEV.effective_start_date
4043: AND EEV.effective_end_date

Line 4480: from pay_input_values_f ipv

4476: hr_utility.set_location('Shadow elename = '||v_shadow_ele_name, 38 );
4477:
4478: select 'Y'
4479: into v_arrears_flag
4480: from pay_input_values_f ipv
4481: where ipv.name = 'Clear Arrears'
4482: and p_date_earned BETWEEN ipv.effective_start_date
4483: AND ipv.effective_end_date
4484: and ipv.element_type_id = p_eletype_id;