[Home] [Help]
106: ,ppa.report_qualifier
107: ,ppa.report_type
108: ,ppa.report_category
109: ,ppa.legislative_parameters
110: from pay_payroll_actions ppa
111: where payroll_action_id = cp_payroll_action_id;
112:
113: ld_start_date DATE;
114: ld_end_date DATE;
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
198: and ppa.action_type = ''X''
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
236: and ppa.action_type = 'X'
321: ,paa.tax_unit_id
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:
392: SELECT pghn2.entity_id
393: FROM per_gen_hierarchy pgh
394: ,per_gen_hierarchy_versions pghv
395: ,per_gen_hierarchy_nodes pghn2 -- establishment organizations
396: ,pay_payroll_actions ppa
397: where ppa.payroll_action_id = p_payroll_action_id
398: and pgh.hierarchy_id = p_est_hierarchy_id
399: and pgh.business_group_id = ppa.business_group_id
400: and pgh.hierarchy_id = pghv.hierarchy_id
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
463: and ue.user_entity_name = 'A_SQWL_MONTH' || to_char(cp_month_of_quarter) || '_COUNT'
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
640: AND paa.tax_unit_id = p_tax_unit_id
697:
698: --get the hierarchy version and establishment from legislative paramters
699: SELECT ppa.legislative_parameters
700: INTO l_ppa_legislative_parameters
701: FROM pay_payroll_actions ppa
702: where ppa.payroll_action_id = p_payroll_action_id;
703:
704: hr_utility.set_location(gv_package || '.' || l_procedure , 20);
705:
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
804: AND psr.state_code = ppa.report_qualifier;
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;
858:
913:
914: Select psif.sit_exists
915: into l_sit_exists
916: from pay_us_state_tax_info_f psif,
917: pay_payroll_actions ppa
918: where ppa.payroll_action_id = p_payroll_action_id
919: and psif.state_code = substr(l_jurisdiction,1,2)
920: and ppa.effective_date
921: BETWEEN psif.effective_start_date AND psif.effective_end_date
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
984: AND psr.state_code = ppa.report_qualifier;