[Home] [Help]
76: ***26-Feb-08 vdabgar 115.47 6839263 Modified proc spawn_archive_reports,csr_params and csr_report_params cursors
77: *** to call the concurrent programs accordingly.
78: ***18-Mar-08 avenkatk 115.48 6839263 Backed out changes from assignment_action_code, initialization_code
79: ***21-Mar-08 avenkatk 115.49 6839263 Added Logic to set the OPP Template options for PDF output
80: ***13-Feb-09 mdubasi 115.50 7590936 Replaced secure view hr_organization_units with hr_all_organization_units
81: *** in the cursor c_employee_details
82: ***11-Dec-09 dduvvuri 115.51 9113084 Added RANGE_PERSON_ID for Payroll Reconciliation Detail Report
83: ***22-Dec-09 dduvvuri 115.52 9113084 Restructured the logic in assignment_action_code to use all Range
84: *** Cursors at one place and Old cursors at one place for code clarity
412: per_assignments_f paaf,
413: pay_payroll_actions ppa,
414: pay_payroll_actions ppa1,
415: pay_assignment_actions paa,
416: hr_organization_units hou,
417: per_periods_of_service pps
418: -- ,per_assignment_status_types past
419: where ppa.payroll_action_id = c_payroll_action_id
420: and paa.assignment_id = paaf.assignment_id
464: per_assignments_f paaf,
465: pay_payroll_actions ppa,
466: pay_payroll_actions ppa1,
467: pay_assignment_actions paa,
468: hr_organization_units hou,
469: per_periods_of_service pps,
470: pay_population_ranges ppr
471: where ppa.payroll_action_id = c_payroll_action_id
472: and ppr.payroll_action_id = ppa.payroll_action_id
519: per_assignments_f paaf,
520: pay_payroll_actions ppa,
521: pay_payroll_actions ppa1,
522: pay_assignment_actions paa,
523: hr_organization_units hou,
524: per_periods_of_service pps
525: where ppa.payroll_action_id = c_payroll_action_id
526: and paa.assignment_id = paaf.assignment_id
527: and pap.person_id between c_start_person and c_end_person
566: per_assignments_f paaf,
567: pay_payroll_actions ppa,
568: pay_payroll_actions ppa1,
569: pay_assignment_actions paa,
570: hr_organization_units hou,
571: per_periods_of_service pps,
572: pay_population_ranges ppr
573: where ppa.payroll_action_id = c_payroll_action_id
574: and ppr.payroll_action_id = ppa.payroll_action_id