APPS.PAY_AU_SOE_PKG dependencies on PAY_RUN_RESULTS

Line 876: pay_run_results prr,

872: cursor c_get_super_fund_name (p_assignment_action_id number,p_date_earned date,p_source_id number)
873: is
874: select distinct prrv.result_value ,prr.element_entry_id
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

Line 901: pay_run_results prr,

897: cursor c_get_ae_super_fund_name (p_assignment_action_id number,p_date_earned date,p_source_id number)
898: is
899: select distinct prrv.result_value ,prr.element_entry_id
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,

Line 933: pay_run_results prr,

929: is
930: select distinct prrv.result_value ,prr.element_entry_id
931: from pay_element_entries_f pee,
932: pay_element_entries_f pee1,
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,

Line 934: pay_run_results prr1,

930: select distinct prrv.result_value ,prr.element_entry_id
931: from pay_element_entries_f pee,
932: pay_element_entries_f pee1,
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

Line 1132: p_run_result_id IN pay_run_results.run_result_ID%TYPE,

1128: (
1129: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1130: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1131: p_pay_bases_id IN per_all_assignments_f.pay_basis_id%TYPE,
1132: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1133: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1134: )
1135: RETURN NUMBER
1136: IS

Line 1146: from pay_run_results prr,

1142: l_temp NUMBER := NULL;
1143:
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

Line 1246: p_run_result_id IN pay_run_results.run_result_ID%TYPE,

1242: FUNCTION get_element_payment_rate
1243: (
1244: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
1245: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1246: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1247: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1248: )
1249: RETURN NUMBER
1250: IS

Line 1327: p_run_result_id IN pay_run_results.run_result_ID%TYPE,

1323:
1324: FUNCTION get_leave_taken_hours
1325: (
1326: p_element_type_id IN pay_element_entries_f.element_entry_id%TYPE,
1327: p_run_result_id IN pay_run_results.run_result_ID%TYPE,
1328: p_effective_date IN pay_payroll_actions.effective_date%TYPE
1329: )
1330: RETURN NUMBER
1331: IS