[Home] [Help]
94: -- This cursor gets the screen_entry_value from pay_element_entry_values_f.
95: -- This is the salary amount obtained when the pay basis isn't null.
96: -- The pay basis and assignment_id are passed in by the view.
97: -- A check is made on the effective date of pay_element_entry_values_f
98: -- and pay_element_entries_f as they're datetracked.
99: ------------------------------------------------------------------------
100: function get_salary
101: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
102: p_assignment_id in pay_element_entries_f.assignment_id%type,
98: -- and pay_element_entries_f as they're datetracked.
99: ------------------------------------------------------------------------
100: function get_salary
101: (p_pay_basis_id in per_pay_bases.pay_basis_id%type,
102: p_assignment_id in pay_element_entries_f.assignment_id%type,
103: p_effective_date in date)
104: return varchar2 is
105:
106: cursor salary
104: return varchar2 is
105:
106: cursor salary
107: (c_pay_basis_id per_pay_bases.pay_basis_id%type,
108: c_assignment_id pay_element_entries_f.assignment_id%type,
109: c_effective_date date) is
110: select pev.screen_entry_value
111: from per_pay_bases ppb,
112: pay_element_entries_f pee,
108: c_assignment_id pay_element_entries_f.assignment_id%type,
109: c_effective_date date) is
110: select pev.screen_entry_value
111: from per_pay_bases ppb,
112: pay_element_entries_f pee,
113: pay_element_entry_values_f pev
114: where pee.assignment_id = c_assignment_id
115: and ppb.pay_basis_id = c_pay_basis_id
116: and pee.element_entry_id = pev.element_entry_id
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,
867: p_business_group_id per_all_assignments_f.business_group_id%TYPE)
868: return varchar2
869:
870: is
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
909: and pee.source_id=pee1.element_entry_id
910: and prr.element_entry_id=pee1.element_entry_id
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
909: and pee.source_id=pee1.element_entry_id
910: and prr.element_entry_id=pee1.element_entry_id
911: and piv.input_value_id=prrv.input_value_id
927: /* for bug 5983711 for retro entries */
928: cursor c_get_rr_super_fund_name(p_assignment_action_id number,p_date_earned date,p_source_id number)
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,
928: cursor c_get_rr_super_fund_name(p_assignment_action_id number,p_date_earned date,p_source_id number)
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,
957:
958: cursor c_get_third_party_payment_id(p_element_entry_id number,p_assignment_id number,p_date_earned date)
959: is
960: select PERSONAL_PAYMENT_METHOD_ID
961: from pay_element_entries_f pee
962: where element_entry_id=p_element_entry_id
963: and assignment_id=p_assignment_id
964: and p_date_earned between pee.effective_start_date and pee.effective_end_date;
965:
989: /* for bug 5983711 */
990: cursor c_get_creator_type(p_source_id number)
991: is
992: select creator_type
993: from pay_element_entries_f
994: where element_entry_id=p_source_id;
995:
996: l_fund_name varchar2(100);
997: l_element_entry_id number ;
1126:
1127: FUNCTION get_element_payment_hours
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: )
1241:
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
1322:
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