[Home] [Help]
189: hr_utility.set_location(gv_package || '.range_code', 20);
190:
191: lv_sql_string :=
192: 'select distinct paa.assignment_id
193: from pay_assignment_actions paa -- SQWL assignment action
194: , pay_payroll_actions ppa
195: where ppa.business_group_id = ' || ln_business_group_id || '
196: and ppa.effective_date between to_date(''' || to_char(ld_start_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257
197: and to_date(''' || to_char(ld_end_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257
227: select paa.assignment_id,
228: ppa.effective_date,
229: paa.tax_unit_id,
230: paa.assignment_action_id
231: from pay_assignment_actions paa -- SQWL assignment action
232: , pay_payroll_actions ppa
233: where ppa.business_group_id = cp_business_group_id
234: and ppa.effective_date between cp_start_date
235: and cp_end_date
284: exit;
285: end if;
286:
287: hr_utility.set_location(gv_package || '.action_creation', 50);
288: select pay_assignment_actions_s.nextval
289: into ln_locking_action_id
290: from dual;
291:
292: -- **** CHECK FOR SUI WAGES HERE **** ----
290: from dual;
291:
292: -- **** CHECK FOR SUI WAGES HERE **** ----
293:
294: -- insert into pay_assignment_actions.
295: hr_nonrun_asact.insact(ln_locking_action_id, ln_assignment_id,
296: p_payroll_action_id, p_chunk, ln_emp_tax_unit_id);
297: hr_utility.set_location(gv_package || '.action_creation', 60);
298:
298:
299: -- insert an interlock to this action
300: hr_nonrun_asact.insint(ln_locking_action_id, ln_assignment_action_id);
301:
302: update pay_assignment_actions paa
303: set paa.serial_number = ln_assignment_action_id
304: where paa.assignment_action_id = ln_locking_action_id;
305:
306: hr_utility.set_location(gv_package || '.action_creation', 60);
322: ,paa.serial_number
323: ,ppa.business_group_id
324: ,ppa.effective_date
325: FROM pay_payroll_actions ppa,
326: pay_assignment_actions paa
327: WHERE ppa.payroll_action_id = p_payroll_action_id
328: AND ppa.payroll_action_id = paa.payroll_action_id;
329:
330: CURSOR c_asg_loc_mon ( p_ass_act_id number
454: select fai.value,
455: ppa.report_qualifier
456: from ff_archive_items fai,
457: ff_user_entities ue,
458: pay_assignment_actions paa,
459: pay_payroll_actions ppa
460: where fai.context1 = cp_sqwl_assact
461: and paa.assignment_action_id = fai.context1
462: and fai.user_entity_id = ue.user_entity_id
631: AND pus.state_code = p_state_code
632: AND EXISTS
633: (
634: SELECT null
635: FROM pay_assignment_actions paa,
636: pay_payroll_actions ppa
637: WHERE ppa.effective_date BETWEEN trunc(p_effective_date,'Q')
638: AND p_effective_date
639: AND ppa.payroll_action_id = paa.payroll_action_id
795: CLOSE c_get_sui_subject;
796: BEGIN
797: SELECT psr.jurisdiction_code
798: INTO l_sqwl_jurisdiction_code
799: FROM pay_assignment_actions paa,
800: pay_payroll_actions ppa,
801: pay_state_rules psr
802: WHERE paa.assignment_action_id = l_sqwl_assact
803: AND ppa.payroll_action_id = paa.payroll_action_id
849: -- Need to set l_state_code to the state of the l_sqwl_jurisdiction
850:
851: SELECT report_qualifier
852: INTO l_state_abbrev
853: FROM pay_assignment_actions paa,
854: pay_payroll_actions ppa
855: WHERE ppa.payroll_action_id = paa.payroll_action_id
856: AND paa.assignment_action_id = l_sqwl_assact;
857: CLOSE c_get_sui_subject;
975: -- Bug fix 5399921 START
976:
977: SELECT psr.jurisdiction_code
978: INTO l_sqwl_jurisdiction_code
979: FROM pay_assignment_actions paa,
980: pay_payroll_actions ppa,
981: pay_state_rules psr
982: WHERE paa.assignment_action_id = l_sqwl_assact
983: AND ppa.payroll_action_id = paa.payroll_action_id