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 1083: FROM pay_input_values_f IPV,

1079:
1080: begin
1081: SELECT IPV.input_value_id
1082: INTO v_inpval_id
1083: FROM pay_input_values_f IPV,
1084: pay_element_types_f ELT
1085: WHERE ELT.element_name = 'Regular Wages'
1086: and p_period_start BETWEEN ELT.effective_start_date
1087: AND ELT.effective_end_date

Line 1117: FROM pay_input_values_f IPV,

1113: hr_utility.trace('In RATE CODE');
1114:
1115: SELECT IPV.input_value_id
1116: INTO v_inpval_id
1117: FROM pay_input_values_f IPV,
1118: pay_element_types_f ELT
1119: WHERE ELT.element_name = 'Regular Wages'
1120: and p_period_start BETWEEN ELT.effective_start_date
1121: AND ELT.effective_end_date

Line 1152: FROM pay_input_values_f IPV,

1148: hr_utility.trace('in MONTHLY SALARY');
1149:
1150: SELECT IPV.input_value_id
1151: INTO v_inpval_id
1152: FROM pay_input_values_f IPV,
1153: pay_element_types_f ELT
1154: WHERE ELT.element_name = 'Regular Salary'
1155: and p_period_start BETWEEN ELT.effective_start_date
1156: AND ELT.effective_end_date

Line 3222: pay_input_values_f IPV

3218: SELECT RRV.result_value
3219: INTO v_dedn_proc
3220: FROM pay_run_result_values RRV,
3221: pay_run_results PRR,
3222: pay_input_values_f IPV
3223: WHERE PRR.assignment_action_id = p_assact_id
3224: AND RRV.result_value <> 'A'
3225: AND RRV.run_result_id = PRR.run_result_id
3226: AND IPV.input_value_id = RRV.input_value_id

Line 3322: pay_input_values_f IPV

3318: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3319: INTO sepcheck_flag
3320: FROM pay_element_entry_values_f EEV,
3321: pay_element_entries_f ELE,
3322: pay_input_values_f IPV
3323: WHERE ELE.assignment_id = p_ass_id
3324: AND p_date_earned BETWEEN ELE.effective_start_date
3325: AND ELE.effective_end_date
3326: AND ELE.element_entry_id = EEV.element_entry_id

Line 3362: FROM pay_input_values_f IPV

3358: 'IMPUTED EARNINGS',
3359: 'NON-PAYROLL PAYMENTS')
3360: AND NOT EXISTS
3361: (SELECT 'X'
3362: FROM pay_input_values_f IPV
3363: WHERE IPV.element_type_id = ELT.element_type_id
3364: AND p_date_earned BETWEEN IPV.effective_start_date
3365: and IPV.effective_end_date
3366: AND UPPER(IPV.name) = 'SEPARATE CHECK');

Line 3484: pay_input_values_f IPV,

3480: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3481: EEV.element_entry_id
3482: FROM pay_element_entries_f ELE,
3483: pay_element_entry_values_f EEV,
3484: pay_input_values_f IPV,
3485: pay_element_types_f ELT
3486: WHERE ELE.assignment_id = p_ass_id
3487: AND p_date_earned BETWEEN ELE.effective_start_date
3488: AND ELE.effective_end_date

Line 3508: pay_input_values_f IPV

3504: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3505: FROM pay_element_entry_values_f EEV,
3506: pay_element_entries_f ELE,
3507: pay_element_types_f ELT,
3508: pay_input_values_f IPV
3509: WHERE ELE.assignment_id = p_ass_id
3510: AND p_date_earned BETWEEN ELE.effective_start_date
3511: AND ELE.effective_end_date
3512: AND ELE.element_entry_id = EEV.element_entry_id

Line 3563: pay_input_values_f ipv

3559: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3560: FROM pay_element_links_f pel,
3561: pay_element_entries_f ele,
3562: pay_element_entry_values_f eev,
3563: pay_input_values_f ipv
3564: WHERE pel.element_type_id = v_eletype_id
3565: AND p_date_earned BETWEEN pel.effective_start_date
3566: AND pel.effective_end_date
3567: AND ele.element_link_id = pel.element_link_id

Line 3582: pay_input_values_f ipv

3578: EEV.element_entry_id
3579: FROM pay_element_links_f pel,
3580: pay_element_entries_f ele,
3581: pay_element_entry_values_f eev,
3582: pay_input_values_f ipv
3583: WHERE pel.element_type_id = v_eletype_id
3584: AND p_date_earned BETWEEN pel.effective_start_date
3585: AND pel.effective_end_date
3586: AND ele.element_link_id = pel.element_link_id

Line 3600: pay_input_values_f ipv

3596: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3597: FROM pay_element_links_f pel,
3598: pay_element_entries_f ele,
3599: pay_element_entry_values_f eev,
3600: pay_input_values_f ipv
3601: WHERE pel.element_type_id = v_eletype_id
3602: AND p_date_earned BETWEEN pel.effective_start_date
3603: AND pel.effective_end_date
3604: AND ele.element_link_id = pel.element_link_id

Line 3617: pay_input_values_f IPV,

3613: CURSOR get_grosses IS
3614: SELECT fnd_number.canonical_to_number(RRV.result_value)
3615: FROM pay_run_result_values RRV,
3616: pay_run_results RRS,
3617: pay_input_values_f IPV,
3618: pay_element_types_f ELT
3619: WHERE RRV.input_value_id = IPV.input_value_id
3620: AND RRV.run_result_id = RRS.run_result_id
3621: AND RRS.element_type_id = ELT.element_type_id

Line 3715: pay_input_values_f IPV,

3711: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3712: INTO v_tew_rcode
3713: FROM pay_element_entries_f ELE,
3714: pay_element_entry_values_f EEV,
3715: pay_input_values_f IPV,
3716: pay_element_types_f ELT
3717: WHERE ELE.assignment_id = p_ass_id
3718: AND EEV.element_entry_id = v_entry_id
3719: AND ELE.element_entry_id = EEV.element_entry_id

Line 3760: pay_input_values_f IPV,

3756: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3757: INTO v_use_regwage
3758: FROM pay_element_entries_f ELE,
3759: pay_element_entry_values_f EEV,
3760: pay_input_values_f IPV,
3761: pay_element_types_f ELT
3762: WHERE ELE.assignment_id = p_ass_id
3763: AND p_date_earned BETWEEN ELE.effective_start_date
3764: AND ELE.effective_end_date

Line 3788: pay_input_values_f IPV,

3784: INTO v_regwage_rate,
3785: v_entry_id
3786: FROM pay_element_entries_f ELE,
3787: pay_element_entry_values_f EEV,
3788: pay_input_values_f IPV,
3789: pay_element_types_f ELT
3790: WHERE ELE.assignment_id = p_ass_id
3791: AND p_date_earned BETWEEN ele.effective_start_date
3792: AND ele.effective_end_date

Line 3814: pay_input_values_f IPV,

3810: SELECT /*+ ORDERED */ NVL(EEV.screen_entry_value, 'NOT ENTERED')
3811: INTO v_regwage_rcode
3812: FROM pay_element_entries_f ELE,
3813: pay_element_entry_values_f EEV,
3814: pay_input_values_f IPV,
3815: pay_element_types_f ELT
3816: WHERE ELE.assignment_id = p_ass_id
3817: AND p_date_earned between ELE.effective_start_date
3818: AND ELE.effective_end_date

Line 3850: pay_input_values_f IPV,

3846: SELECT /*+ ORDERED */ COUNT(IPV.input_value_id)
3847: INTO v_use_regsal
3848: FROM pay_element_entries_f ELE,
3849: pay_element_entry_values_f EEV,
3850: pay_input_values_f IPV,
3851: pay_element_types_f ELT
3852: WHERE ELE.assignment_id = p_ass_id
3853: AND p_date_earned BETWEEN ELE.effective_start_date
3854: AND ELE.effective_end_date

Line 3876: pay_input_values_f IPV,

3872: SELECT /*+ ORDERED */ NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3873: INTO v_regsal_mosal
3874: FROM pay_element_entries_f ELE,
3875: pay_element_entry_values_f EEV,
3876: pay_input_values_f IPV,
3877: pay_element_types_f ELT
3878: WHERE ELE.assignment_id = p_ass_id
3879: AND p_date_earned BETWEEN ELE.effective_start_date
3880: AND ELE.effective_end_date

Line 4001: pay_input_values_f IPV

3997: INTO v_rate_rcode
3998: FROM pay_element_entry_values_f EEV,
3999: pay_element_entries_f ELE,
4000: pay_element_types_f ELT,
4001: pay_input_values_f IPV
4002: WHERE ELE.assignment_id = p_ass_id
4003: AND ELE.element_entry_id = EEV.element_entry_id
4004: AND p_date_earned BETWEEN EEV.effective_start_date
4005: AND EEV.effective_end_date

Line 4030: pay_input_values_f IPV

4026: INTO v_rate_mult_count
4027: FROM pay_element_entry_values_f EEV,
4028: pay_element_entries_f ELE,
4029: pay_element_types_f ELT,
4030: pay_input_values_f IPV
4031: WHERE ELE.assignment_id = p_ass_id
4032: AND ELE.element_entry_id = EEV.element_entry_id
4033: AND p_date_earned BETWEEN EEV.effective_start_date
4034: AND EEV.effective_end_date

Line 4048: pay_input_values_f IPV

4044: INTO v_rate_multiple
4045: FROM pay_element_entry_values_f EEV,
4046: pay_element_entries_f ELE,
4047: pay_element_types_f ELT,
4048: pay_input_values_f IPV
4049: WHERE ELE.assignment_id = p_ass_id
4050: AND ELE.element_entry_id = EEV.element_entry_id
4051: AND p_date_earned BETWEEN EEV.effective_start_date
4052: AND EEV.effective_end_date

Line 4496: from pay_input_values_f ipv

4492: hr_utility.set_location('Shadow elename = '||v_shadow_ele_name, 38 );
4493:
4494: select 'Y'
4495: into v_arrears_flag
4496: from pay_input_values_f ipv
4497: where ipv.name = 'Clear Arrears'
4498: and p_date_earned BETWEEN ipv.effective_start_date
4499: AND ipv.effective_end_date
4500: and ipv.element_type_id = p_eletype_id;

Line 4591: from PAY_ELEMENT_ENTRY_VALUES_F eev , PAY_INPUT_VALUES_F ip

4587: and rcu.retro_component_usage_id = pes.retro_component_usage_id
4588: and pes.legislation_code is null ; */
4589:
4590: select (sum(to_number(nvl(screen_entry_value,'0')))) into l_arrear_contr_value
4591: from PAY_ELEMENT_ENTRY_VALUES_F eev , PAY_INPUT_VALUES_F ip
4592: where eev.input_value_id = ip.input_value_id
4593: and ip.name like 'Arrears Contr'
4594: and element_entry_id in ( select element_entry_id -- element entry for arrear contr
4595: from pay_element_entries_f