APPS.PAY_AU_SOE_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 862: p_element_reporting_name in pay_element_types_f.reporting_name%type,

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,

Line 879: pay_element_types_f pet,

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%'

Line 904: pay_element_types_f pet,

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

Line 937: pay_element_types_f pet,

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

Line 1138: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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;

Line 1148: pay_element_types_f pet,

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

Line 1166: (c_element_type_id pay_element_types_f.element_type_id%TYPE

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

Line 1252: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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:

Line 1258: (c_element_type_id pay_element_types_f.element_type_id%TYPE

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

Line 1333: l_element_type_id pay_element_types_f.element_type_id%TYPE;

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:

Line 1339: (c_element_type_id pay_element_types_f.element_type_id%TYPE

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