[Home] [Help]
62: ** 09-Feb-2004 punmehta 115.37 Bug# 3245909 - Coding Standards in get_pp_action
63: ** 02-FEB-2004 abhkumar 115.38 Bug# 3665680 - Coding Standards in Cr_element_type_id
64: ** 02-FEB-2004 abhkumar 115.39 Bug# 3665680 - Modfied Code to remove gscc warnings
65: ** 07-JUL-2004 srrajago 115.40 Bug# 3724089 - Modified the cursor 'c_get_unprocessed_periods_num' to include table
66: ** per_assignments_f and its joins in the sub-query - Performance Fix.
67: ** 09-AUG-2004 abhkumar 115.41 Bug# 2610141 - Modfied the code to support Legal Employer changes for an assignment.
68: ** 12-AUG-2004 abhkumar 115.42 Bug# 2610141 - Modfied the code to use cursors instead of select query
69: ** 08-SEP-2004 abhkumar 115.43 Bug# 2610141 - Added a flag "p_use_tax_flag" to function periods_since_hire_date and paid_periods_since_hire_date
70: ** to support the versioning of the payroll tax formula.
291: select count(ptp1.time_period_id) /*Bug 4438644, 6001930, 7228256*/
292: from per_time_periods ptp
293: ,per_time_periods ptp1
294: where exists (select 'EXISTS' from
295: per_assignments_f paf,
296: hr_soft_coding_keyflex hsck
297: where paf.assignment_id = p_assignment_id
298: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
299: and hsck.segment1 = p_tax_unit_id
633: is
634: select count(DISTINCT ptp.time_period_id)
635: from per_time_periods ptp
636: where exists (select 'EXISTS' from
637: per_assignments_f paf,
638: hr_soft_coding_keyflex hsck
639: where paf.assignment_id = p_assignment_id
640: and paf.SOFT_CODING_KEYFLEX_ID = hsck.soft_coding_keyflex_id
641: and hsck.segment1 = c_tax_unit_id
666: IS
667: SELECT count(paa.assignment_action_id)
668: FROM pay_assignment_actions paa,
669: pay_payroll_actions ppa,
670: per_assignments_f paf
671: WHERE ppa.effective_date BETWEEN c_start_date AND c_end_date
672: AND ppa.business_group_id = c_business_group_id
673: AND ppa.payroll_action_id = paa.payroll_action_id
674: AND paa.assignment_id = c_assignment_id
975: from per_time_periods
976: where payroll_id = p_payroll_id
977: and start_Date = p_period_start;
978:
979: /* Bug: 3724089 - Performance Fix in the Cursor below. Added table per_assignments_f and its joins in the inner sub-query */
980:
981: cursor c_get_processed_periods_num (v_payroll_id number,
982: v_start_date date,
983: v_end_date date,
986: ) is
987: select DISTINCT ptp.time_period_id, ptp.period_num /*Bug 4438644*/
988: from per_time_periods ptp
989: where exists (select 'EXISTS' from
990: per_assignments_f paf,
991: pay_payroll_actions ppa,
992: pay_assignment_actions paa
993: where ppa.payroll_id = v_payroll_id
994: and ppa.action_type in ('R','Q')