[Home] [Help]
89: ,ppa.report_qualifier
90: ,ppa.report_type
91: ,ppa.report_category
92: ,ppa.legislative_parameters
93: from pay_payroll_actions ppa
94: where payroll_action_id = cp_payroll_action_id;
95:
96: ld_start_date DATE;
97: ld_end_date DATE;
173:
174: lv_sql_string :=
175: 'select distinct paa.assignment_id
176: from pay_assignment_actions paa -- SQWL assignment action
177: , pay_payroll_actions ppa
178: where ppa.business_group_id = ' || ln_business_group_id || '
179: and ppa.effective_date between to_date(''' || to_char(ld_start_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257
180: and to_date(''' || to_char(ld_end_date, 'dd-mon-yyyy') || ''', ''dd-mon-yyyy'') --Bug 3362257
181: and ppa.action_type = ''X''
211: ppa.effective_date,
212: paa.tax_unit_id,
213: paa.assignment_action_id
214: from pay_assignment_actions paa -- SQWL assignment action
215: , pay_payroll_actions ppa
216: where ppa.business_group_id = cp_business_group_id
217: and ppa.effective_date between cp_start_date
218: and cp_end_date
219: and ppa.action_type = 'X'
303: SELECT paa.assignment_id
304: ,paa.tax_unit_id
305: ,paa.serial_number
306: ,ppa.business_group_id
307: FROM pay_payroll_actions ppa,
308: pay_assignment_actions paa
309: WHERE ppa.payroll_action_id = p_payroll_action_id
310: AND ppa.payroll_action_id = paa.payroll_action_id;
311:
374: SELECT pghn2.entity_id
375: FROM per_gen_hierarchy pgh
376: ,per_gen_hierarchy_versions pghv
377: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
378: ,pay_payroll_actions ppa
379: where ppa.payroll_action_id = p_payroll_action_id
380: and pgh.hierarchy_id = p_est_hierarchy_id
381: and pgh.business_group_id = ppa.business_group_id
382: and pgh.hierarchy_id = pghv.hierarchy_id
437: ppa.report_qualifier
438: from ff_archive_items fai,
439: ff_user_entities ue,
440: pay_assignment_actions paa,
441: pay_payroll_actions ppa
442: where fai.context1 = cp_sqwl_assact
443: and paa.assignment_action_id = fai.context1
444: and fai.user_entity_id = ue.user_entity_id
445: and ue.user_entity_name = 'A_SQWL_MONTH' || to_char(cp_month_of_quarter) || '_COUNT'
542:
543: --get the hierarchy version and establishment from legislative paramters
544: SELECT ppa.legislative_parameters
545: INTO l_ppa_legislative_parameters
546: FROM pay_payroll_actions ppa
547: where ppa.payroll_action_id = p_payroll_action_id;
548:
549: hr_utility.set_location(gv_package || '.' || l_procedure , 20);
550:
649: BEGIN
650: SELECT psr.jurisdiction_code
651: INTO l_sqwl_jurisdiction_code
652: FROM pay_assignment_actions paa,
653: pay_payroll_actions ppa,
654: pay_state_rules psr
655: WHERE paa.assignment_action_id = l_sqwl_assact
656: AND ppa.payroll_action_id = paa.payroll_action_id
657: AND psr.state_code = ppa.report_qualifier;
677:
678: SELECT report_qualifier
679: INTO l_state_abbrev
680: FROM pay_assignment_actions paa,
681: pay_payroll_actions ppa
682: WHERE ppa.payroll_action_id = paa.payroll_action_id
683: AND paa.assignment_action_id = l_sqwl_assact;
684:
685: CLOSE c_get_sui_subject;
716:
717: Select psif.sit_exists
718: into l_sit_exists
719: from pay_us_state_tax_info_f psif,
720: pay_payroll_actions ppa
721: where ppa.payroll_action_id = p_payroll_action_id
722: and psif.state_code = substr(l_jurisdiction,1,2)
723: and ppa.effective_date
724: BETWEEN psif.effective_start_date AND psif.effective_end_date
742:
743: SELECT psr.jurisdiction_code
744: INTO l_sqwl_jurisdiction_code
745: FROM pay_assignment_actions paa,
746: pay_payroll_actions ppa,
747: pay_state_rules psr
748: WHERE paa.assignment_action_id = l_sqwl_assact
749: AND ppa.payroll_action_id = paa.payroll_action_id
750: AND psr.state_code = ppa.report_qualifier;