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_ELEMENT_TYPES_F

Line 750: pay_element_types_f ELT

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
754: AND IPV.effective_end_date

Line 774: pay_element_types_f ELT

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
778: AND IPV.effective_end_date

Line 798: pay_element_types_f ELT

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
802: AND IPV.effective_end_date

Line 2593: PAY_ELEMENT_TYPES_F ELT

2589: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2590: INTO v_ele_exists
2591: FROM PAY_ELEMENT_ENTRIES_F ELE,
2592: PAY_ELEMENT_LINKS_F ELI,
2593: PAY_ELEMENT_TYPES_F ELT
2594: WHERE p_date_earned
2595: BETWEEN ELE.effective_start_date
2596: AND ELE.effective_end_date
2597: AND ELE.assignment_id = p_asst_id

Line 2689: FROM pay_element_types_f

2685: --
2686: begin
2687: SELECT element_information3
2688: INTO v_proc_run_type
2689: FROM pay_element_types_f
2690: WHERE p_date_earned
2691: BETWEEN effective_start_date
2692: AND effective_end_date
2693: AND element_type_id = p_ele_type_id;

Line 2730: FROM pay_element_types_f

2726:
2727: begin
2728: SELECT element_information3
2729: INTO v_proc_run_type
2730: FROM pay_element_types_f
2731: WHERE p_date_earned
2732: BETWEEN effective_start_date
2733: AND effective_end_date
2734: AND element_type_id = p_ele_type_id;

Line 2896: FROM pay_element_types_f ELT,

2892: begin
2893:
2894: SELECT ECL.classification_name
2895: INTO v_ele_class_name
2896: FROM pay_element_types_f ELT,
2897: pay_element_classifications ECL
2898: WHERE ECL.classification_id = ELT.classification_id
2899: AND ELT.business_group_id + 0 = p_bg_id
2900: AND p_date_earned

Line 2990: pay_element_types_f ELT,

2986: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
2987: INTO sepcheck_flag
2988: FROM pay_element_entries_f ELE,
2989: pay_element_links_f ELL,
2990: pay_element_types_f ELT,
2991: pay_element_classifications ECL
2992: WHERE ELE.assignment_id = p_ass_id
2993: AND p_date_earned BETWEEN
2994: ELE.effective_start_date and ELE.effective_end_date

Line 3128: FROM pay_element_types_f

3124: --
3125: --
3126: CURSOR cur_element_type_id(p_element_name varchar2) IS
3127: SELECT element_type_id
3128: FROM pay_element_types_f
3129: WHERE element_name = p_element_name
3130: AND legislation_code = 'CA';
3131:
3132: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;

Line 3132: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;

3128: FROM pay_element_types_f
3129: WHERE element_name = p_element_name
3130: AND legislation_code = 'CA';
3131:
3132: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3133: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3134: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3135:
3136: --

Line 3133: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;

3129: WHERE element_name = p_element_name
3130: AND legislation_code = 'CA';
3131:
3132: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3133: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3134: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3135:
3136: --
3137: -- local cursors

Line 3134: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;

3130: AND legislation_code = 'CA';
3131:
3132: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3133: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3134: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3135:
3136: --
3137: -- local cursors
3138: --

Line 3161: pay_element_types_f ELT,

3157: ELT.element_name,
3158: FRA.formula_name
3159: FROM pay_element_entries_f ELE,
3160: pay_element_links_f ELI,
3161: pay_element_types_f ELT,
3162: pay_status_processing_rules_f SPR,
3163: ff_formulas_f FRA
3164: WHERE FRA.formula_id = SPR.formula_id
3165: AND p_date_earned

Line 3251: pay_element_types_f ELT

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
3255: AND RRS.assignment_action_id = p_ass_action_id

Line 3338: pay_element_types_f ELT,

3334: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
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

Line 3411: pay_element_types_f ELT,

3407: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
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

Line 3577: pay_element_types_f ELT,

3573: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
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

Line 3607: pay_element_types_f ELT,

3603: SELECT COUNT(0)
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

Line 3626: pay_element_types_f ELT,

3622: SELECT NVL(EEV.screen_entry_value, 0)
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

Line 4345: ,pay_element_types_f pet

4341: ,piv.name
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