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 PAY_INPUT_VALUES_F

Line 755: FROM pay_input_values_f IPV,

751: begin
752: hr_utility.set_location('calculate_period_earnings', 13);
753: SELECT IPV.input_value_id
754: INTO v_inpval_id
755: FROM pay_input_values_f IPV,
756: pay_element_types_f ELT
757: WHERE UPPER(ELT.element_name) = 'REGULAR WAGES'
758: AND ELT.element_type_id = IPV.element_type_id
759: AND p_period_start BETWEEN IPV.effective_start_date

Line 779: FROM pay_input_values_f IPV,

775: begin
776: hr_utility.set_location('calculate_period_earnings', 15);
777: SELECT IPV.input_value_id
778: INTO v_inpval_id
779: FROM pay_input_values_f IPV,
780: pay_element_types_f ELT
781: WHERE UPPER(ELT.element_name) = 'REGULAR WAGES'
782: AND ELT.element_type_id = IPV.element_type_id
783: AND p_period_start BETWEEN IPV.effective_start_date

Line 803: FROM pay_input_values_f IPV,

799: begin
800: hr_utility.set_location('calculate_period_earnings', 17);
801: SELECT IPV.input_value_id
802: INTO v_inpval_id
803: FROM pay_input_values_f IPV,
804: pay_element_types_f ELT
805: WHERE UPPER(ELT.element_name) = 'REGULAR SALARY'
806: AND ELT.element_type_id = IPV.element_type_id
807: AND p_period_start BETWEEN IPV.effective_start_date

Line 2909: pay_input_values_f IPV

2905: SELECT RRV.result_value
2906: INTO v_dedn_proc
2907: FROM pay_run_result_values RRV,
2908: pay_run_results PRR,
2909: pay_input_values_f IPV
2910: WHERE PRR.assignment_action_id = p_assact_id
2911: AND RRV.result_value <> 'A'
2912: AND RRV.run_result_id = PRR.run_result_id
2913: AND IPV.input_value_id = RRV.input_value_id

Line 3005: pay_input_values_f IPV

3001: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
3002: INTO sepcheck_flag
3003: FROM pay_element_entry_values_f EEV,
3004: pay_element_entries_f ELE,
3005: pay_input_values_f IPV
3006: WHERE ELE.assignment_id = p_ass_id
3007: AND p_date_earned
3008: BETWEEN ELE.effective_start_date AND ELE.effective_end_date
3009: AND ELE.element_entry_id = EEV.element_entry_id

Line 3045: FROM pay_input_values_f IPV

3041: 'IMPUTED EARNINGS',
3042: 'NON-PAYROLL PAYMENTS')
3043: AND NOT EXISTS
3044: (SELECT 'X'
3045: FROM pay_input_values_f IPV
3046: WHERE IPV.element_type_id = ELT.element_type_id
3047: AND p_date_earned BETWEEN
3048: IPV.effective_start_date and IPV.effective_end_date
3049: AND UPPER(IPV.name) = 'SEPARATE CHECK');

Line 3181: pay_input_values_f IPV

3177: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3178: EEV.element_entry_id
3179: FROM pay_element_entry_values_f EEV,
3180: pay_element_entries_f ELE,
3181: pay_input_values_f IPV
3182: WHERE ELE.assignment_id = p_ass_id
3183: AND ELE.element_entry_id = EEV.element_entry_id
3184: AND p_date_earned
3185: BETWEEN EEV.effective_start_date

Line 3233: pay_input_values_f ipv

3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3230: FROM pay_element_links_f pel,
3231: pay_element_entries_f ele,
3232: pay_element_entry_values_f eev,
3233: pay_input_values_f ipv
3234: WHERE pel.element_type_id = v_eletype_id
3235: AND p_date_earned BETWEEN pel.effective_start_date
3236: AND pel.effective_end_date
3237: AND ele.element_link_id = pel.element_link_id

Line 3252: pay_input_values_f ipv

3248: EEV.element_entry_id
3249: FROM pay_element_links_f pel,
3250: pay_element_entries_f ele,
3251: pay_element_entry_values_f eev,
3252: pay_input_values_f ipv
3253: WHERE pel.element_type_id = v_eletype_id
3254: AND p_date_earned BETWEEN pel.effective_start_date
3255: AND pel.effective_end_date
3256: AND ele.element_link_id = pel.element_link_id

Line 3270: pay_input_values_f ipv

3266: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3267: FROM pay_element_links_f pel,
3268: pay_element_entries_f ele,
3269: pay_element_entry_values_f eev,
3270: pay_input_values_f ipv
3271: WHERE pel.element_type_id = v_eletype_id
3272: AND p_date_earned BETWEEN pel.effective_start_date
3273: AND pel.effective_end_date
3274: AND ele.element_link_id = pel.element_link_id

Line 3287: pay_input_values_f IPV,

3283: CURSOR get_grosses IS
3284: SELECT RRV.result_value
3285: FROM pay_run_result_values RRV,
3286: pay_run_results RRS,
3287: pay_input_values_f IPV,
3288: pay_element_types_f ELT
3289: WHERE RRV.input_value_id = IPV.input_value_id
3290: AND RRV.run_result_id = RRS.run_result_id
3291: AND RRS.element_type_id = ELT.element_type_id

Line 3376: pay_input_values_f IPV

3372: INTO v_tew_rcode
3373: FROM pay_element_entry_values_f EEV,
3374: pay_element_entries_f ELE,
3375: pay_element_types_f ELT,
3376: pay_input_values_f IPV
3377: WHERE ELE.assignment_id = p_ass_id
3378: AND ELE.element_entry_id = EEV.element_entry_id
3379: AND p_date_earned
3380: BETWEEN EEV.effective_start_date

Line 3414: pay_input_values_f IPV

3410: SELECT COUNT(IPV.input_value_id)
3411: INTO v_use_regwage
3412: FROM pay_element_entry_values_f EEV,
3413: pay_element_entries_f ELE,
3414: pay_input_values_f IPV
3415: WHERE ELE.assignment_id = p_ass_id
3416: AND ELE.element_entry_id = EEV.element_entry_id
3417: AND p_date_earned
3418: BETWEEN EEV.effective_start_date

Line 3432: pay_input_values_f IPV

3428: INTO v_regwage_rate,
3429: v_entry_id
3430: FROM pay_element_entry_values_f EEV,
3431: pay_element_entries_f ELE,
3432: pay_input_values_f IPV
3433: WHERE ELE.assignment_id = p_ass_id
3434: AND ELE.element_entry_id = EEV.element_entry_id
3435: AND p_date_earned
3436: BETWEEN EEV.effective_start_date

Line 3449: pay_input_values_f IPV

3445: INTO v_regwage_rcode
3446: FROM pay_element_entry_values_f EEV,
3447: pay_element_entries_f ELE,
3448: pay_element_types_f ELT,
3449: pay_input_values_f IPV
3450: WHERE ELE.assignment_id = p_ass_id
3451: AND ELE.element_entry_id = EEV.element_entry_id
3452: AND p_date_earned
3453: BETWEEN EEV.effective_start_date

Line 3476: pay_input_values_f IPV

3472: SELECT COUNT(IPV.input_value_id)
3473: INTO v_use_regsal
3474: FROM pay_element_entry_values_f EEV,
3475: pay_element_entries_f ELE,
3476: pay_input_values_f IPV
3477: WHERE ELE.assignment_id = p_ass_id
3478: AND ELE.element_entry_id = EEV.element_entry_id
3479: AND p_date_earned
3480: BETWEEN EEV.effective_start_date

Line 3492: pay_input_values_f IPV

3488: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3489: INTO v_regsal_mosal
3490: FROM pay_element_entry_values_f EEV,
3491: pay_element_entries_f ELE,
3492: pay_input_values_f IPV
3493: WHERE ELE.assignment_id = p_ass_id
3494: AND ELE.element_entry_id = EEV.element_entry_id
3495: AND p_date_earned
3496: BETWEEN EEV.effective_start_date

Line 3615: pay_input_values_f IPV

3611: INTO v_rate_rcode
3612: FROM pay_element_entry_values_f EEV,
3613: pay_element_entries_f ELE,
3614: pay_element_types_f ELT,
3615: pay_input_values_f IPV
3616: WHERE ELE.assignment_id = p_ass_id
3617: AND ELE.element_entry_id = EEV.element_entry_id
3618: AND p_date_earned
3619: BETWEEN EEV.effective_start_date

Line 3645: pay_input_values_f IPV

3641: INTO v_rate_mult_count
3642: FROM pay_element_entry_values_f EEV,
3643: pay_element_entries_f ELE,
3644: pay_element_types_f ELT,
3645: pay_input_values_f IPV
3646: WHERE ELE.assignment_id = p_ass_id
3647: AND ELE.element_entry_id = EEV.element_entry_id
3648: AND p_date_earned
3649: BETWEEN EEV.effective_start_date

Line 3664: pay_input_values_f IPV

3660: INTO v_rate_multiple
3661: FROM pay_element_entry_values_f EEV,
3662: pay_element_entries_f ELE,
3663: pay_element_types_f ELT,
3664: pay_input_values_f IPV
3665: WHERE ELE.assignment_id = p_ass_id
3666: AND ELE.element_entry_id = EEV.element_entry_id
3667: AND p_date_earned
3668: BETWEEN EEV.effective_start_date

Line 4035: from pay_input_values_f ipv

4031: hr_utility.set_location('Shadow elename = '||v_shadow_ele_name, 38 );
4032:
4033: select 'Y'
4034: into v_arrears_flag
4035: from pay_input_values_f ipv
4036: where ipv.name = 'Clear Arrears'
4037: and p_date_earned BETWEEN ipv.effective_start_date
4038: AND ipv.effective_end_date
4039: and ipv.element_type_id = p_eletype_id;

Line 4383: ,pay_input_values_f piv

4379: FROM pay_element_entry_values_f peev
4380: ,pay_element_entries_f pee
4381: ,pay_element_links_f pel
4382: ,pay_element_types_f pet
4383: ,pay_input_values_f piv
4384: ,per_pay_bases ppb
4385: ,per_all_assignments_f paa
4386: WHERE paa.assignment_id = p_assignment_id
4387: AND paa.business_group_id = p_bus_grp_id