[Home] [Help]
139: ,ppa.report_qualifier
140: ,ppa.report_type
141: ,ppa.report_category
142: ,ppa.legislative_parameters
143: from pay_payroll_actions ppa
144: where payroll_action_id = cp_payroll_action_id;
145:
146: ld_start_date DATE;
147: ld_end_date DATE;
270: from hr_organization_information hoi
271: where org_information_context = 'Employer Identification'
272: and exists (select 'x'
273: from pay_assignment_actions paa,
274: pay_payroll_actions ppa
275: where ppa.payroll_action_id = paa.payroll_action_id
276: and ppa.business_group_id = cp_business_group_id
277: and ppa.effective_date between cp_start_date
278: and cp_end_date
373: hr_utility.set_location(gv_package || '.range_code', 60);
374:
375: lv_sql_string :=
376: 'select distinct paf.person_id
377: from pay_payroll_actions ppa,
378: pay_assignment_actions paa,
379: per_assignments_f paf
380: where ppa.business_group_id = ' || ln_business_group_id || '
381: and ppa.effective_date
397: (select /*+ ORDERED */
398: ''x''
399: from pay_action_interlocks pai,
400: pay_assignment_actions paa1,
401: pay_payroll_actions ppa1
402: where pai.locked_action_id = paa.assignment_action_id
403: and paa1.assignment_action_id = pai.locking_action_id
404: and ppa1.payroll_action_id = paa1.payroll_action_id
405: and ppa1.action_type =''X''
454: select paa.assignment_id,
455: ppa.effective_date,
456: paa.tax_unit_id,
457: paa.assignment_action_id
458: from pay_payroll_actions ppa,
459: pay_assignment_actions paa,
460: per_assignments_f paf
461: where ppa.business_group_id = cp_business_group_id
462: and ppa.effective_date between cp_start_date
476: (select /*+ ORDERED */
477: 'x'
478: from pay_action_interlocks pai,
479: pay_assignment_actions paa1,
480: pay_payroll_actions ppa1
481: where pai.locked_action_id = paa.assignment_action_id
482: and paa1.assignment_action_id = pai.locking_action_id
483: and ppa1.payroll_action_id = paa1.payroll_action_id
484: and ppa1.action_type = 'X'
1065: ,nvl(sum(to_number(action_information29)),0) action_information29
1066: ,action_information30
1067: from pay_action_information pai,
1068: pay_assignment_actions paa,
1069: pay_payroll_actions ppa -- Bug 3343962
1070: where pai.tax_unit_id = cp_tax_unit_id
1071: and paa.payroll_action_id = cp_payroll_action_id
1072: and ppa.payroll_action_id = cp_payroll_action_id
1073: and ppa.payroll_action_id = paa.payroll_action_id
1122: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information5),action_information5))),0) action_information32 --Added for Bug#9872952
1123: ,nvl(sum(to_number(decode(pai.action_information_category,'US FEDERAL',decode(action_information27,'Y',0,action_information23),action_information23))),0) action_information33 --Added for Bug#9872952
1124: from pay_action_information pai,
1125: pay_assignment_actions paa,
1126: pay_payroll_actions ppa
1127: where pai.tax_unit_id = cp_tax_unit_id
1128: and paa.payroll_action_id = cp_payroll_action_id
1129: and ppa.payroll_action_id = cp_payroll_action_id
1130: and ppa.payroll_action_id = paa.payroll_action_id