[Home] [Help]
34: ** 14-Mar-2003 srrajago 2850738 115.11 Included the join paa.period_of_service_id = pps.period_of_service_id
35: ** in the cursor csr_hire_date so as to pick up the correct hire date
36: ** incase of rehire.
37: ** 30-May-2003 kaverma 2920731 115.12 Replaced tables per_all_assignments_f and per_all_people_f by secured views
38: ** per_assignments_f and per_people_f respectively form the queries
39: ** 24-Jul-2003 srrajago 3062419 115.13 Added two variables l_fin_start_date and l_fin_end_date for storing the
40: ** financial year start and end date respectively. p_periods value ( end_date
41: ** value only) modified so that it returns different values for IR56B and
42: ** IR56F and IR56G.
73: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
74:
75:
76: FUNCTION get_emoluments
77: ( p_assignment_id in per_assignments_f.assignment_id%TYPE
78: , p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
79: , p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE
80: , p_reporting_year in number) RETURN g_emol_details_tab IS
81:
132: SELECT pps.date_start,
133: pps.actual_termination_date
134: FROM per_periods_of_service pps,
135: per_people_f ppf,
136: per_assignments_f paf
137: WHERE paf.person_id = ppf.person_id
138: AND pps.person_id = paf.person_id
139: AND paf.assignment_id = p_assignment_id
140: AND paf.period_of_service_id = pps.period_of_service_id; /* Bug No : 2850738 */
428: /*
429: * Bug 4864213 - Added the following function get_quarters_start_date to return the quaters start date
430: */
431:
432: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
433: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
434: RETURN DATE IS
435:
436: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;