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 756: pay_element_types_f ELT

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

Line 780: pay_element_types_f ELT

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

Line 804: pay_element_types_f ELT

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

Line 2630: PAY_ELEMENT_TYPES_F ELT

2626: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
2627: INTO v_ele_exists
2628: FROM PAY_ELEMENT_ENTRIES_F ELE,
2629: PAY_ELEMENT_LINKS_F ELI,
2630: PAY_ELEMENT_TYPES_F ELT
2631: WHERE p_date_earned
2632: BETWEEN ELE.effective_start_date
2633: AND ELE.effective_end_date
2634: AND ELE.assignment_id = p_asst_id

Line 2726: FROM pay_element_types_f

2722: --
2723: begin
2724: SELECT element_information3
2725: INTO v_proc_run_type
2726: FROM pay_element_types_f
2727: WHERE p_date_earned
2728: BETWEEN effective_start_date
2729: AND effective_end_date
2730: AND element_type_id = p_ele_type_id;

Line 2767: FROM pay_element_types_f

2763:
2764: begin
2765: SELECT element_information3
2766: INTO v_proc_run_type
2767: FROM pay_element_types_f
2768: WHERE p_date_earned
2769: BETWEEN effective_start_date
2770: AND effective_end_date
2771: AND element_type_id = p_ele_type_id;

Line 2933: FROM pay_element_types_f ELT,

2929: begin
2930:
2931: SELECT ECL.classification_name
2932: INTO v_ele_class_name
2933: FROM pay_element_types_f ELT,
2934: pay_element_classifications ECL
2935: WHERE ECL.classification_id = ELT.classification_id
2936: AND ELT.business_group_id + 0 = p_bg_id
2937: AND p_date_earned

Line 3027: pay_element_types_f ELT,

3023: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3024: INTO sepcheck_flag
3025: FROM pay_element_entries_f ELE,
3026: pay_element_links_f ELL,
3027: pay_element_types_f ELT,
3028: pay_element_classifications ECL
3029: WHERE ELE.assignment_id = p_ass_id
3030: AND p_date_earned BETWEEN
3031: ELE.effective_start_date and ELE.effective_end_date

Line 3165: FROM pay_element_types_f

3161: --
3162: --
3163: CURSOR cur_element_type_id(p_element_name varchar2) IS
3164: SELECT element_type_id
3165: FROM pay_element_types_f
3166: WHERE element_name = p_element_name
3167: AND legislation_code = 'CA';
3168:
3169: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;

Line 3169: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;

3165: FROM pay_element_types_f
3166: WHERE element_name = p_element_name
3167: AND legislation_code = 'CA';
3168:
3169: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3170: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3171: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3172:
3173: --

Line 3170: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;

3166: WHERE element_name = p_element_name
3167: AND legislation_code = 'CA';
3168:
3169: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3170: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3171: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3172:
3173: --
3174: -- local cursors

Line 3171: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;

3167: AND legislation_code = 'CA';
3168:
3169: l_reg_sal_ele_id pay_element_types_f.element_type_id%TYPE;
3170: l_reg_wages_ele_id pay_element_types_f.element_type_id%TYPE;
3171: l_time_entry_ele_id pay_element_types_f.element_type_id%TYPE;
3172:
3173: --
3174: -- local cursors
3175: --

Line 3198: pay_element_types_f ELT,

3194: ELT.element_name,
3195: FRA.formula_name
3196: FROM pay_element_entries_f ELE,
3197: pay_element_links_f ELI,
3198: pay_element_types_f ELT,
3199: pay_status_processing_rules_f SPR,
3200: ff_formulas_f FRA
3201: WHERE FRA.formula_id = SPR.formula_id
3202: AND p_date_earned

Line 3288: pay_element_types_f ELT

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

Line 3375: pay_element_types_f ELT,

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

Line 3448: pay_element_types_f ELT,

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

Line 3614: pay_element_types_f ELT,

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

Line 3644: pay_element_types_f ELT,

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

Line 3663: pay_element_types_f ELT,

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

Line 4382: ,pay_element_types_f pet

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