[Home] [Help]
1074:
1075: hr_utility.trace(' p_pay_basis IS NULL');
1076: hr_utility.trace('In p_inpval_name = RATE');
1077: /* Changed the element_name and name to init case and added
1078: the date join for pay_element_types_f */
1079:
1080: begin
1081: SELECT IPV.input_value_id
1082: INTO v_inpval_id
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
1088: and ELT.element_type_id = IPV.element_type_id
1106: end;
1107: --
1108: ELSIF UPPER(p_inpval_name) = 'RATE CODE' THEN
1109: /* Changed the element_name and name to init case and added
1110: the date join for pay_element_types_f */
1111:
1112: begin
1113: hr_utility.trace('In RATE CODE');
1114:
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
1122: and ELT.element_type_id = IPV.element_type_id
1141: --
1142: ELSIF UPPER(p_inpval_name) = 'MONTHLY SALARY' THEN
1143:
1144: /* Changed the element_name and name to init case and added
1145: the date join for pay_element_types_f */
1146:
1147: begin
1148: hr_utility.trace('in MONTHLY SALARY');
1149:
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
1157: and ELT.element_type_id = IPV.element_type_id
3008: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3009: INTO v_ele_exists
3010: FROM PAY_ELEMENT_ENTRIES_F ELE,
3011: PAY_ELEMENT_LINKS_F ELI,
3012: PAY_ELEMENT_TYPES_F ELT
3013: WHERE p_date_earned BETWEEN ELE.effective_start_date
3014: AND ELE.effective_end_date
3015: AND ELE.assignment_id = p_asst_id
3016: AND ELE.element_link_id = ELI.element_link_id
3107: --
3108: begin
3109: SELECT element_information3
3110: INTO v_proc_run_type
3111: FROM pay_element_types_f
3112: WHERE p_date_earned BETWEEN effective_start_date
3113: AND effective_end_date
3114: AND element_type_id = p_ele_type_id;
3115: --
3149:
3150: begin
3151: SELECT element_information3
3152: INTO v_proc_run_type
3153: FROM pay_element_types_f
3154: WHERE p_date_earned BETWEEN effective_start_date
3155: AND effective_end_date
3156: AND element_type_id = p_ele_type_id;
3157:
3243: begin
3244:
3245: SELECT ECL.classification_name
3246: INTO v_ele_class_name
3247: FROM pay_element_types_f ELT,
3248: pay_element_classifications ECL
3249: WHERE ECL.classification_id = ELT.classification_id
3250: AND ELT.business_group_id + 0 = p_bg_id
3251: AND p_date_earned BETWEEN ELT.effective_start_date
3340: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3341: INTO sepcheck_flag
3342: FROM pay_element_entries_f ELE,
3343: pay_element_links_f ELL,
3344: pay_element_types_f ELT,
3345: pay_element_classifications ECL
3346: WHERE ELE.assignment_id = p_ass_id
3347: AND p_date_earned BETWEEN ELE.effective_start_date
3348: and ELE.effective_end_date
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
3489: AND ELE.element_entry_id = EEV.element_entry_id
3503: /* CURSOR get_tew_rcode IS
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
3531: ELT.element_name,
3532: FRA.formula_name
3533: FROM pay_element_entries_f ELE,
3534: pay_element_links_f ELI,
3535: pay_element_types_f ELT,
3536: pay_status_processing_rules_f SPR,
3537: ff_formulas_f FRA
3538: WHERE FRA.formula_id = SPR.formula_id
3539: AND p_date_earned BETWEEN SPR.effective_start_date
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
3622: AND RRS.assignment_action_id = p_ass_action_id
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
3720: AND p_date_earned BETWEEN EEV.effective_start_date
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
3765: AND ELE.element_entry_id = EEV.element_entry_id
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
3793: AND ELE.element_entry_id = EEV.element_entry_id
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
3819: AND ELE.element_entry_id = EEV.element_entry_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
3855: AND ELE.element_entry_id = EEV.element_entry_id
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
3881: AND ELE.element_entry_id = EEV.element_entry_id
3996: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
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
4025: SELECT COUNT(0)
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
4043: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
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
4564:
4565: /* Changes done for bug # 6970340 starts */
4566: begin
4567: select to_number(nvl(element_information19,0)) into l_arr_eletype_id /*Element Type id of Spl features */
4568: from pay_element_types_f
4569: where element_type_id = p_eletype_id ;
4570: exception when others then null ;
4571: end;
4572: