858: If Superannuation Fund Name is null,then element reporting name will be returned*/
859:
860: function super_fund_name
861: (p_source_id in number,
862: p_element_reporting_name in pay_element_types_f.reporting_name%type,
863: p_date_earned in pay_payroll_actions.date_earned%type,
864: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
865: p_assignment_id in per_all_assignments_f.assignment_id%type,
866: p_element_entry_id in pay_element_entries_f.PERSONAL_PAYMENT_METHOD_ID%TYPE,
875: from
876: pay_run_results prr,
877: pay_run_result_values prrv,
878: pay_input_values_f piv,
879: pay_element_types_f pet,
880: pay_element_classifications pec
881: where prr.source_id= p_source_id
882: and piv.input_value_id=prrv.input_value_id
883: and piv.name like '%Fund%Name%'
900: from
901: pay_run_results prr,
902: pay_run_result_values prrv,
903: pay_input_values_f piv,
904: pay_element_types_f pet,
905: pay_element_classifications pec,
906: pay_element_entries_f pee,
907: pay_element_entries_f pee1
908: where pee.element_entry_id=p_source_id
933: pay_run_results prr,
934: pay_run_results prr1,
935: pay_run_result_values prrv,
936: pay_input_values_f piv,
937: pay_element_types_f pet,
938: pay_element_classifications pec
939: where pee.element_entry_id=p_source_id
940: and pee.source_id =prr.run_result_id
941: and prr.source_id= pee1.element_entry_id
1134: )
1135: RETURN NUMBER
1136: IS
1137:
1138: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1139: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1140:
1141: l_result NUMBER := NULL;
1142: l_temp NUMBER := NULL;
1144: CURSOR Cr_value IS (
1145: SELECT prv.result_value
1146: from pay_run_results prr,
1147: pay_run_result_values prv,
1148: pay_element_types_f pet,
1149: pay_input_values_f piv
1150: where prr.assignment_action_id = p_assignment_action_id
1151: and prv.run_result_id = prr.run_result_id
1152: and prv.input_value_id = piv.input_value_id
1162: AND ppb.pay_basis_id = p_pay_bases_id);
1163:
1164: /* Bug 5967108 - Added Check for Input with Name - Hours */
1165: CURSOR get_hours_input_value
1166: (c_element_type_id pay_element_types_f.element_type_id%TYPE
1167: ,c_effective_date date)
1168: IS
1169: SELECT pivf.input_value_id
1170: ,pivf.name
1248: )
1249: RETURN NUMBER
1250: IS
1251:
1252: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1253: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1254:
1255: l_result number := NULL;
1256:
1254:
1255: l_result number := NULL;
1256:
1257: CURSOR get_rate_input_value
1258: (c_element_type_id pay_element_types_f.element_type_id%TYPE
1259: ,c_effective_date date)
1260: IS
1261: SELECT pivf.input_value_id
1262: FROM pay_input_values_f pivf
1329: )
1330: RETURN NUMBER
1331: IS
1332:
1333: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1334: l_input_value_id pay_input_values_f.input_value_id%TYPE;
1335:
1336: l_result number := NULL;
1337:
1335:
1336: l_result number := NULL;
1337:
1338: CURSOR get_hours_input_value
1339: (c_element_type_id pay_element_types_f.element_type_id%TYPE
1340: ,c_effective_date date)
1341: IS
1342: SELECT pivf.input_value_id
1343: FROM pay_input_values_f pivf