[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.
66: p_result_table pay_balance_pkg.t_detailed_bal_out_tab;
67:
68:
69: FUNCTION get_emoluments
70: ( p_assignment_id in per_assignments_f.assignment_id%TYPE
71: , p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
72: , p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE
73: , p_reporting_year in number) RETURN g_emol_details_tab IS
74:
123: SELECT pps.date_start,
124: pps.actual_termination_date
125: FROM per_periods_of_service pps,
126: per_people_f ppf,
127: per_assignments_f paf
128: WHERE paf.person_id = ppf.person_id
129: AND pps.person_id = paf.person_id
130: AND paf.assignment_id = p_assignment_id
131: AND paf.period_of_service_id = pps.period_of_service_id; /* Bug No : 2850738 */
378: /*
379: * Bug 4864213 - Added the following function get_quarters_start_date to return the quaters start date
380: */
381:
382: FUNCTION get_quarters_start_date(p_assignment_id in per_assignments_f.assignment_id%TYPE,
383: p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
384: RETURN DATE IS
385:
386: l_quarters_start_date pay_hk_ir56_quarters_actions_v.start_date%TYPE;