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

745: begin
746: hr_utility.set_location('calculate_period_earnings', 13);
747: SELECT IPV.input_value_id
748: INTO v_inpval_id
749: FROM pay_input_values_f IPV,
750: pay_element_types_f ELT
751: WHERE UPPER(ELT.element_name) = 'REGULAR WAGES'
752: AND ELT.element_type_id = IPV.element_type_id
753: AND p_period_start BETWEEN IPV.effective_start_date

Line 773: FROM pay_input_values_f IPV,

769: begin
770: hr_utility.set_location('calculate_period_earnings', 15);
771: SELECT IPV.input_value_id
772: INTO v_inpval_id
773: FROM pay_input_values_f IPV,
774: pay_element_types_f ELT
775: WHERE UPPER(ELT.element_name) = 'REGULAR WAGES'
776: AND ELT.element_type_id = IPV.element_type_id
777: AND p_period_start BETWEEN IPV.effective_start_date

Line 797: FROM pay_input_values_f IPV,

793: begin
794: hr_utility.set_location('calculate_period_earnings', 17);
795: SELECT IPV.input_value_id
796: INTO v_inpval_id
797: FROM pay_input_values_f IPV,
798: pay_element_types_f ELT
799: WHERE UPPER(ELT.element_name) = 'REGULAR SALARY'
800: AND ELT.element_type_id = IPV.element_type_id
801: AND p_period_start BETWEEN IPV.effective_start_date

Line 2872: pay_input_values_f IPV

2868: SELECT RRV.result_value
2869: INTO v_dedn_proc
2870: FROM pay_run_result_values RRV,
2871: pay_run_results PRR,
2872: pay_input_values_f IPV
2873: WHERE PRR.assignment_action_id = p_assact_id
2874: AND RRV.result_value <> 'A'
2875: AND RRV.run_result_id = PRR.run_result_id
2876: AND IPV.input_value_id = RRV.input_value_id

Line 2968: pay_input_values_f IPV

2964: SELECT DECODE(COUNT(IPV.input_value_id), 0, 'N', 'Y')
2965: INTO sepcheck_flag
2966: FROM pay_element_entry_values_f EEV,
2967: pay_element_entries_f ELE,
2968: pay_input_values_f IPV
2969: WHERE ELE.assignment_id = p_ass_id
2970: AND p_date_earned
2971: BETWEEN ELE.effective_start_date AND ELE.effective_end_date
2972: AND ELE.element_entry_id = EEV.element_entry_id

Line 3008: FROM pay_input_values_f IPV

3004: 'IMPUTED EARNINGS',
3005: 'NON-PAYROLL PAYMENTS')
3006: AND NOT EXISTS
3007: (SELECT 'X'
3008: FROM pay_input_values_f IPV
3009: WHERE IPV.element_type_id = ELT.element_type_id
3010: AND p_date_earned BETWEEN
3011: IPV.effective_start_date and IPV.effective_end_date
3012: AND UPPER(IPV.name) = 'SEPARATE CHECK');

Line 3144: pay_input_values_f IPV

3140: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3141: EEV.element_entry_id
3142: FROM pay_element_entry_values_f EEV,
3143: pay_element_entries_f ELE,
3144: pay_input_values_f IPV
3145: WHERE ELE.assignment_id = p_ass_id
3146: AND ELE.element_entry_id = EEV.element_entry_id
3147: AND p_date_earned
3148: BETWEEN EEV.effective_start_date

Line 3196: pay_input_values_f ipv

3192: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3193: FROM pay_element_links_f pel,
3194: pay_element_entries_f ele,
3195: pay_element_entry_values_f eev,
3196: pay_input_values_f ipv
3197: WHERE pel.element_type_id = v_eletype_id
3198: AND p_date_earned BETWEEN pel.effective_start_date
3199: AND pel.effective_end_date
3200: AND ele.element_link_id = pel.element_link_id

Line 3215: pay_input_values_f ipv

3211: EEV.element_entry_id
3212: FROM pay_element_links_f pel,
3213: pay_element_entries_f ele,
3214: pay_element_entry_values_f eev,
3215: pay_input_values_f ipv
3216: WHERE pel.element_type_id = v_eletype_id
3217: AND p_date_earned BETWEEN pel.effective_start_date
3218: AND pel.effective_end_date
3219: AND ele.element_link_id = pel.element_link_id

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

3246: CURSOR get_grosses IS
3247: SELECT RRV.result_value
3248: FROM pay_run_result_values RRV,
3249: pay_run_results RRS,
3250: pay_input_values_f IPV,
3251: pay_element_types_f ELT
3252: WHERE RRV.input_value_id = IPV.input_value_id
3253: AND RRV.run_result_id = RRS.run_result_id
3254: AND RRS.element_type_id = ELT.element_type_id

Line 3339: pay_input_values_f IPV

3335: INTO v_tew_rcode
3336: FROM pay_element_entry_values_f EEV,
3337: pay_element_entries_f ELE,
3338: pay_element_types_f ELT,
3339: pay_input_values_f IPV
3340: WHERE ELE.assignment_id = p_ass_id
3341: AND ELE.element_entry_id = EEV.element_entry_id
3342: AND p_date_earned
3343: BETWEEN EEV.effective_start_date

Line 3377: pay_input_values_f IPV

3373: SELECT COUNT(IPV.input_value_id)
3374: INTO v_use_regwage
3375: FROM pay_element_entry_values_f EEV,
3376: pay_element_entries_f ELE,
3377: pay_input_values_f IPV
3378: WHERE ELE.assignment_id = p_ass_id
3379: AND ELE.element_entry_id = EEV.element_entry_id
3380: AND p_date_earned
3381: BETWEEN EEV.effective_start_date

Line 3395: pay_input_values_f IPV

3391: INTO v_regwage_rate,
3392: v_entry_id
3393: FROM pay_element_entry_values_f EEV,
3394: pay_element_entries_f ELE,
3395: pay_input_values_f IPV
3396: WHERE ELE.assignment_id = p_ass_id
3397: AND ELE.element_entry_id = EEV.element_entry_id
3398: AND p_date_earned
3399: BETWEEN EEV.effective_start_date

Line 3412: pay_input_values_f IPV

3408: INTO v_regwage_rcode
3409: FROM pay_element_entry_values_f EEV,
3410: pay_element_entries_f ELE,
3411: pay_element_types_f ELT,
3412: pay_input_values_f IPV
3413: WHERE ELE.assignment_id = p_ass_id
3414: AND ELE.element_entry_id = EEV.element_entry_id
3415: AND p_date_earned
3416: BETWEEN EEV.effective_start_date

Line 3439: pay_input_values_f IPV

3435: SELECT COUNT(IPV.input_value_id)
3436: INTO v_use_regsal
3437: FROM pay_element_entry_values_f EEV,
3438: pay_element_entries_f ELE,
3439: pay_input_values_f IPV
3440: WHERE ELE.assignment_id = p_ass_id
3441: AND ELE.element_entry_id = EEV.element_entry_id
3442: AND p_date_earned
3443: BETWEEN EEV.effective_start_date

Line 3455: pay_input_values_f IPV

3451: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3452: INTO v_regsal_mosal
3453: FROM pay_element_entry_values_f EEV,
3454: pay_element_entries_f ELE,
3455: pay_input_values_f IPV
3456: WHERE ELE.assignment_id = p_ass_id
3457: AND ELE.element_entry_id = EEV.element_entry_id
3458: AND p_date_earned
3459: BETWEEN EEV.effective_start_date

Line 3578: pay_input_values_f IPV

3574: INTO v_rate_rcode
3575: FROM pay_element_entry_values_f EEV,
3576: pay_element_entries_f ELE,
3577: pay_element_types_f ELT,
3578: pay_input_values_f IPV
3579: WHERE ELE.assignment_id = p_ass_id
3580: AND ELE.element_entry_id = EEV.element_entry_id
3581: AND p_date_earned
3582: BETWEEN EEV.effective_start_date

Line 3608: pay_input_values_f IPV

3604: INTO v_rate_mult_count
3605: FROM pay_element_entry_values_f EEV,
3606: pay_element_entries_f ELE,
3607: pay_element_types_f ELT,
3608: pay_input_values_f IPV
3609: WHERE ELE.assignment_id = p_ass_id
3610: AND ELE.element_entry_id = EEV.element_entry_id
3611: AND p_date_earned
3612: BETWEEN EEV.effective_start_date

Line 3627: pay_input_values_f IPV

3623: INTO v_rate_multiple
3624: FROM pay_element_entry_values_f EEV,
3625: pay_element_entries_f ELE,
3626: pay_element_types_f ELT,
3627: pay_input_values_f IPV
3628: WHERE ELE.assignment_id = p_ass_id
3629: AND ELE.element_entry_id = EEV.element_entry_id
3630: AND p_date_earned
3631: BETWEEN EEV.effective_start_date

Line 3998: from pay_input_values_f ipv

3994: hr_utility.set_location('Shadow elename = '||v_shadow_ele_name, 38 );
3995:
3996: select 'Y'
3997: into v_arrears_flag
3998: from pay_input_values_f ipv
3999: where ipv.name = 'Clear Arrears'
4000: and p_date_earned BETWEEN ipv.effective_start_date
4001: AND ipv.effective_end_date
4002: and ipv.element_type_id = p_eletype_id;

Line 4346: ,pay_input_values_f piv

4342: FROM pay_element_entry_values_f peev
4343: ,pay_element_entries_f pee
4344: ,pay_element_links_f pel
4345: ,pay_element_types_f pet
4346: ,pay_input_values_f piv
4347: ,per_pay_bases ppb
4348: ,per_all_assignments_f paa
4349: WHERE paa.assignment_id = p_assignment_id
4350: AND paa.business_group_id = p_bus_grp_id