[Home] [Help]
58: *** 18-Jun-08 avenkatk 115.45 7138494 Added Changes for RANGE_PERSON_ID
59: *** 18-Jun-08 avenkatk 115.46 7138494 Modified Allowance Cursor for peformance
60: *** 18-Dec-08 skshin 115.47 7571001 Modified archive_element_details, summary_rep_populate_allowance and get_allowance_balances
61: *** 27-Jan-09 skshin 115.48 7571001 Modified Cursor c_ps_element_details to have separate cursor c_ps_alw_details for allowances and removed summary_rep_populate_allowance procedure and p_allowance_exist in archive_element_details
62: *** 13-Feb-09 mdubasi 115.49 7590936 Replaced secure view hr_organization_units with hr_all_organization_units
63: *** in the cursor c_employee_details
64: *** 23-Feb-09 mdubasi 115.50 7590936 Replaced second secure view hr_organization_units with hr_all_organization_units
65: *** in the cursor c_employee_details
66: *** 28-Apr-09 pmatamsr 115.51 8441044 Cursor c_get_pay_effective_date is modified to consider Lump Sum E payments for payment summary gross calculation
60: *** 18-Dec-08 skshin 115.47 7571001 Modified archive_element_details, summary_rep_populate_allowance and get_allowance_balances
61: *** 27-Jan-09 skshin 115.48 7571001 Modified Cursor c_ps_element_details to have separate cursor c_ps_alw_details for allowances and removed summary_rep_populate_allowance procedure and p_allowance_exist in archive_element_details
62: *** 13-Feb-09 mdubasi 115.49 7590936 Replaced secure view hr_organization_units with hr_all_organization_units
63: *** in the cursor c_employee_details
64: *** 23-Feb-09 mdubasi 115.50 7590936 Replaced second secure view hr_organization_units with hr_all_organization_units
65: *** in the cursor c_employee_details
66: *** 28-Apr-09 pmatamsr 115.51 8441044 Cursor c_get_pay_effective_date is modified to consider Lump Sum E payments for payment summary gross calculation
67: *** for action types 'B' and 'I'.
68: *** 23-Jun-09 pmatamsr 115.52 8587013 Added changes to support the archival of new balances 'Reportable Employer Superannuation Contributions'
115: Any changes made to this package must be Functionally/Technically tested against both reports.
116: */
117:
118: g_arc_payroll_action_id pay_payroll_actions.payroll_action_id%type;
119: g_business_group_id hr_all_organization_units.organization_id%type;
120: g_debug boolean ;
121: g_package constant varchar2(60) := 'pay_au_rec_det_paysum_mode.'; -- Global to store package name for tracing.
122: g_end_date date;
123: g_start_date date;
780: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
781: ,c_start_person per_all_people_f.person_id%type
782: ,c_end_person per_all_people_f.person_id%type
783: ,c_employee_type per_all_people_f.current_employee_flag%type
784: ,c_business_group_id hr_all_organization_units.organization_id%type
785: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
786: ,c_payroll_id varchar2
787: ,c_fin_year_start date
788: ,c_fin_year_end date
863: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
864: ,c_start_person per_all_people_f.person_id%type
865: ,c_end_person per_all_people_f.person_id%type
866: ,c_employee_type per_all_people_f.current_employee_flag%type
867: ,c_business_group_id hr_all_organization_units.organization_id%type
868: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
869: ,c_payroll_id varchar2
870: ,c_fin_year_start date
871: ,c_fin_year_end date
949: CURSOR csr_range_assignment_paysum
950: (c_payroll_action_id pay_payroll_actions.payroll_action_id%type
951: ,c_chunk NUMBER
952: ,c_employee_type per_all_people_f.current_employee_flag%type
953: ,c_business_group_id hr_all_organization_units.organization_id%type
954: ,c_legal_employer pay_assignment_actions.tax_unit_id%type
955: ,c_payroll_id varchar2
956: ,c_fin_year_start date
957: ,c_fin_year_end date
1270: -- Description : Fetches employee details to be displayed on Report.
1271: -- Latest Values as on End Date is fetched.
1272: --------------------------------------------------------------------+
1273: cursor c_employee_details
1274: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,
1275: c_archive_assignment_action_id number,
1276: c_start_date date,
1277: c_end_date date)
1278: is
1296: per_periods_of_service pps,
1297: per_pay_bases ppb,
1298: per_pay_proposals pro,
1299: per_assignment_status_types past,
1300: hr_all_organization_units hou,
1301: pay_assignment_actions paa1
1302: ,hr_soft_coding_keyflex hsc
1303: ,hr_all_organization_units hou1
1304: -- ,pay_payrolls_f papf /*Bug 4688800*/
1299: per_assignment_status_types past,
1300: hr_all_organization_units hou,
1301: pay_assignment_actions paa1
1302: ,hr_soft_coding_keyflex hsc
1303: ,hr_all_organization_units hou1
1304: -- ,pay_payrolls_f papf /*Bug 4688800*/
1305: where pap.person_id = paa.person_id
1306: and paa.assignment_id = paa1.assignment_id
1307: and paa1.assignment_action_id = c_archive_assignment_action_id
1360: -- Summary Report - Pay Sum Mode
1361: -- Latest Values as on End Date is fetched.
1362: --------------------------------------------------------------------+
1363: cursor c_summary_employee_details
1364: ( c_business_group_id hr_all_organization_units.organization_id%TYPE,
1365: c_archive_assignment_action_id number,
1366: c_start_date date,
1367: c_end_date date)
1368: is
2458: - Negate the amount for foreign tax deductions and classify as Tax Deductions
2459: */
2460: cursor c_ps_element_details
2461: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2462: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2463: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2464: c_start_date date,
2465: c_end_date date)
2466: is
2584: Removed references to hours and rate columns from the cursor ,as they are not displayed anywhere in EOY reports. */
2585: /* bug 12615137 - Added ORDERED hint and re-arranged FROM clause */
2586: cursor c_ps_alw_details
2587: (c_assignment_id pay_assignment_actions.assignment_id%TYPE,
2588: c_business_group_id hr_all_organization_units.organization_id%TYPE,
2589: c_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE,
2590: c_start_date date,
2591: c_end_date date) is
2592: select /*+ ORDERED */ element_name,label, sum(amount) payment