[Home] [Help]
1065:
1066: hr_utility.trace(' p_pay_basis IS NULL');
1067: hr_utility.trace('In p_inpval_name = RATE');
1068: /* Changed the element_name and name to init case and added
1069: the date join for pay_element_types_f */
1070:
1071: begin
1072: SELECT IPV.input_value_id
1073: INTO v_inpval_id
1071: begin
1072: SELECT IPV.input_value_id
1073: INTO v_inpval_id
1074: FROM pay_input_values_f IPV,
1075: pay_element_types_f ELT
1076: WHERE ELT.element_name = 'Regular Wages'
1077: and p_period_start BETWEEN ELT.effective_start_date
1078: AND ELT.effective_end_date
1079: and ELT.element_type_id = IPV.element_type_id
1097: end;
1098: --
1099: ELSIF UPPER(p_inpval_name) = 'RATE CODE' THEN
1100: /* Changed the element_name and name to init case and added
1101: the date join for pay_element_types_f */
1102:
1103: begin
1104: hr_utility.trace('In RATE CODE');
1105:
1105:
1106: SELECT IPV.input_value_id
1107: INTO v_inpval_id
1108: FROM pay_input_values_f IPV,
1109: pay_element_types_f ELT
1110: WHERE ELT.element_name = 'Regular Wages'
1111: and p_period_start BETWEEN ELT.effective_start_date
1112: AND ELT.effective_end_date
1113: and ELT.element_type_id = IPV.element_type_id
1132: --
1133: ELSIF UPPER(p_inpval_name) = 'MONTHLY SALARY' THEN
1134:
1135: /* Changed the element_name and name to init case and added
1136: the date join for pay_element_types_f */
1137:
1138: begin
1139: hr_utility.trace('in MONTHLY SALARY');
1140:
1140:
1141: SELECT IPV.input_value_id
1142: INTO v_inpval_id
1143: FROM pay_input_values_f IPV,
1144: pay_element_types_f ELT
1145: WHERE ELT.element_name = 'Regular Salary'
1146: and p_period_start BETWEEN ELT.effective_start_date
1147: AND ELT.effective_end_date
1148: and ELT.element_type_id = IPV.element_type_id
2999: SELECT DECODE(COUNT(0), 0, 'N', 'Y')
3000: INTO v_ele_exists
3001: FROM PAY_ELEMENT_ENTRIES_F ELE,
3002: PAY_ELEMENT_LINKS_F ELI,
3003: PAY_ELEMENT_TYPES_F ELT
3004: WHERE p_date_earned BETWEEN ELE.effective_start_date
3005: AND ELE.effective_end_date
3006: AND ELE.assignment_id = p_asst_id
3007: AND ELE.element_link_id = ELI.element_link_id
3098: --
3099: begin
3100: SELECT element_information3
3101: INTO v_proc_run_type
3102: FROM pay_element_types_f
3103: WHERE p_date_earned BETWEEN effective_start_date
3104: AND effective_end_date
3105: AND element_type_id = p_ele_type_id;
3106: --
3140:
3141: begin
3142: SELECT element_information3
3143: INTO v_proc_run_type
3144: FROM pay_element_types_f
3145: WHERE p_date_earned BETWEEN effective_start_date
3146: AND effective_end_date
3147: AND element_type_id = p_ele_type_id;
3148:
3234: begin
3235:
3236: SELECT ECL.classification_name
3237: INTO v_ele_class_name
3238: FROM pay_element_types_f ELT,
3239: pay_element_classifications ECL
3240: WHERE ECL.classification_id = ELT.classification_id
3241: AND ELT.business_group_id + 0 = p_bg_id
3242: AND p_date_earned BETWEEN ELT.effective_start_date
3331: SELECT DECODE(COUNT(ELE.element_entry_id), 0, 'N', 'Y')
3332: INTO sepcheck_flag
3333: FROM pay_element_entries_f ELE,
3334: pay_element_links_f ELL,
3335: pay_element_types_f ELT,
3336: pay_element_classifications ECL
3337: WHERE ELE.assignment_id = p_ass_id
3338: AND p_date_earned BETWEEN ELE.effective_start_date
3339: and ELE.effective_end_date
3472: EEV.element_entry_id
3473: FROM pay_element_entries_f ELE,
3474: pay_element_entry_values_f EEV,
3475: pay_input_values_f IPV,
3476: pay_element_types_f ELT
3477: WHERE ELE.assignment_id = p_ass_id
3478: AND p_date_earned BETWEEN ELE.effective_start_date
3479: AND ELE.effective_end_date
3480: AND ELE.element_entry_id = EEV.element_entry_id
3494: /* CURSOR get_tew_rcode IS
3495: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3496: FROM pay_element_entry_values_f EEV,
3497: pay_element_entries_f ELE,
3498: pay_element_types_f ELT,
3499: pay_input_values_f IPV
3500: WHERE ELE.assignment_id = p_ass_id
3501: AND p_date_earned BETWEEN ELE.effective_start_date
3502: AND ELE.effective_end_date
3522: ELT.element_name,
3523: FRA.formula_name
3524: FROM pay_element_entries_f ELE,
3525: pay_element_links_f ELI,
3526: pay_element_types_f ELT,
3527: pay_status_processing_rules_f SPR,
3528: ff_formulas_f FRA
3529: WHERE FRA.formula_id = SPR.formula_id
3530: AND p_date_earned BETWEEN SPR.effective_start_date
3605: SELECT fnd_number.canonical_to_number(RRV.result_value)
3606: FROM pay_run_result_values RRV,
3607: pay_run_results RRS,
3608: pay_input_values_f IPV,
3609: pay_element_types_f ELT
3610: WHERE RRV.input_value_id = IPV.input_value_id
3611: AND RRV.run_result_id = RRS.run_result_id
3612: AND RRS.element_type_id = ELT.element_type_id
3613: AND RRS.assignment_action_id = p_ass_action_id
3703: INTO v_tew_rcode
3704: FROM pay_element_entries_f ELE,
3705: pay_element_entry_values_f EEV,
3706: pay_input_values_f IPV,
3707: pay_element_types_f ELT
3708: WHERE ELE.assignment_id = p_ass_id
3709: AND EEV.element_entry_id = v_entry_id
3710: AND ELE.element_entry_id = EEV.element_entry_id
3711: AND p_date_earned BETWEEN EEV.effective_start_date
3748: INTO v_use_regwage
3749: FROM pay_element_entries_f ELE,
3750: pay_element_entry_values_f EEV,
3751: pay_input_values_f IPV,
3752: pay_element_types_f ELT
3753: WHERE ELE.assignment_id = p_ass_id
3754: AND p_date_earned BETWEEN ELE.effective_start_date
3755: AND ELE.effective_end_date
3756: AND ELE.element_entry_id = EEV.element_entry_id
3776: v_entry_id
3777: FROM pay_element_entries_f ELE,
3778: pay_element_entry_values_f EEV,
3779: pay_input_values_f IPV,
3780: pay_element_types_f ELT
3781: WHERE ELE.assignment_id = p_ass_id
3782: AND p_date_earned BETWEEN ele.effective_start_date
3783: AND ele.effective_end_date
3784: AND ELE.element_entry_id = EEV.element_entry_id
3802: INTO v_regwage_rcode
3803: FROM pay_element_entries_f ELE,
3804: pay_element_entry_values_f EEV,
3805: pay_input_values_f IPV,
3806: pay_element_types_f ELT
3807: WHERE ELE.assignment_id = p_ass_id
3808: AND p_date_earned between ELE.effective_start_date
3809: AND ELE.effective_end_date
3810: AND ELE.element_entry_id = EEV.element_entry_id
3838: INTO v_use_regsal
3839: FROM pay_element_entries_f ELE,
3840: pay_element_entry_values_f EEV,
3841: pay_input_values_f IPV,
3842: pay_element_types_f ELT
3843: WHERE ELE.assignment_id = p_ass_id
3844: AND p_date_earned BETWEEN ELE.effective_start_date
3845: AND ELE.effective_end_date
3846: AND ELE.element_entry_id = EEV.element_entry_id
3864: INTO v_regsal_mosal
3865: FROM pay_element_entries_f ELE,
3866: pay_element_entry_values_f EEV,
3867: pay_input_values_f IPV,
3868: pay_element_types_f ELT
3869: WHERE ELE.assignment_id = p_ass_id
3870: AND p_date_earned BETWEEN ELE.effective_start_date
3871: AND ELE.effective_end_date
3872: AND ELE.element_entry_id = EEV.element_entry_id
3987: SELECT NVL(EEV.screen_entry_value, 'NOT ENTERED')
3988: INTO v_rate_rcode
3989: FROM pay_element_entry_values_f EEV,
3990: pay_element_entries_f ELE,
3991: pay_element_types_f ELT,
3992: pay_input_values_f IPV
3993: WHERE ELE.assignment_id = p_ass_id
3994: AND ELE.element_entry_id = EEV.element_entry_id
3995: AND p_date_earned BETWEEN EEV.effective_start_date
4016: SELECT COUNT(0)
4017: INTO v_rate_mult_count
4018: FROM pay_element_entry_values_f EEV,
4019: pay_element_entries_f ELE,
4020: pay_element_types_f ELT,
4021: pay_input_values_f IPV
4022: WHERE ELE.assignment_id = p_ass_id
4023: AND ELE.element_entry_id = EEV.element_entry_id
4024: AND p_date_earned BETWEEN EEV.effective_start_date
4034: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
4035: INTO v_rate_multiple
4036: FROM pay_element_entry_values_f EEV,
4037: pay_element_entries_f ELE,
4038: pay_element_types_f ELT,
4039: pay_input_values_f IPV
4040: WHERE ELE.assignment_id = p_ass_id
4041: AND ELE.element_entry_id = EEV.element_entry_id
4042: AND p_date_earned BETWEEN EEV.effective_start_date