[Home] [Help]
604: fai1.value
605: FROM ff_archive_items fai1,
606: ff_database_items fdi1,
607: ff_archive_item_contexts faic,
608: ff_contexts fc
609: WHERE fai1.user_entity_id = fdi1.user_entity_id
610: AND fai1.archive_item_id = faic.archive_item_id
611: AND fc.context_id = faic.context_id
612: AND fc.context_name = 'JURISDICTION_CODE'
1039: where hoi.org_information_context = 'Canada Employer Identification'
1040: and hoi.org_information2 = l_pre_organization_id))
1041: )
1042: AND PPY.payroll_id = ASG.payroll_id
1043: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
1044: where pac.assignment_id = asg.assignment_id
1045: and pac.context_id = fc.context_id
1046: and fc.context_name = 'JURISDICTION_CODE'
1047: and pac.context_value = 'QC' )
1075: AND ppa.effective_date between asg.effective_start_date
1076: and asg.effective_end_date
1077: AND EXISTS (select 1
1078: from pay_action_contexts pac,
1079: ff_contexts fc
1080: where pac.assignment_id = paa.assignment_id
1081: and pac.assignment_action_id = paa.assignment_action_id
1082: and pac.context_id = fc.context_id
1083: and fc.context_name ||'' = 'JURISDICTION_CODE'
2008: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
2009: l_step number := 0;
2010: l_county_code varchar2(3);
2011: l_city_code varchar2(4);
2012: l_jursd_context_id ff_contexts.context_id%type;
2013: l_taxunit_context_id ff_contexts.context_id%type;
2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2009: l_step number := 0;
2010: l_county_code varchar2(3);
2011: l_city_code varchar2(4);
2012: l_jursd_context_id ff_contexts.context_id%type;
2013: l_taxunit_context_id ff_contexts.context_id%type;
2014: l_seq_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2015: l_context_id_tab pay_ca_eoy_rl1_archive.number_data_type_table;
2016: l_context_val_tab pay_ca_eoy_rl1_archive.char240_data_type_table;
2017: l_chunk number;
2290: between to_char(all_paf.effective_start_date,'YYYY')
2291: and to_char(all_paf.effective_end_date,'YYYY')
2292: and run_paa.assignment_id = all_paf.assignment_id
2293: and exists (select 1
2294: from pay_action_contexts pac,ff_contexts ffc
2295: where ffc.context_name = 'JURISDICTION_CODE'
2296: and pac.context_id = ffc.context_id
2297: and pac.assignment_id = run_paa.assignment_id
2298: and pac.context_value = 'QC');
2341: per_all_people_f ppf,
2342: pay_payroll_actions ppa,
2343: pay_action_classifications pac,
2344: pay_action_contexts pac1,
2345: ff_contexts fc
2346: where ppf.person_id = cp_person_id
2347: and paf.person_id = ppf.person_id
2348: and paf.assignment_id = paa.assignment_id
2349: and paa.tax_unit_id = cp_tax_unit_id
2466: hr_utility.trace('Initialising Pl/SQL table');
2467:
2468: l_step := 3;
2469:
2470: /* Get the context_id for 'Jurisdiction' from ff_contexts */
2471:
2472: l_step := 5;
2473:
2474: select context_id
2472: l_step := 5;
2473:
2474: select context_id
2475: into l_jursd_context_id
2476: from ff_contexts
2477: where context_name = 'JURISDICTION_CODE';
2478:
2479: select context_id
2480: into l_taxunit_context_id
2477: where context_name = 'JURISDICTION_CODE';
2478:
2479: select context_id
2480: into l_taxunit_context_id
2481: from ff_contexts
2482: where context_name = 'TAX_UNIT_ID';
2483:
2484: l_step := 6;
2485:
4122: and ppa.payroll_id = ppy.payroll_id
4123: and ppy.business_group_id = '||to_char(l_business_group)||'
4124: and exists (select 1
4125: from pay_action_contexts pac,
4126: ff_contexts fc
4127: where pac.assignment_id = paa.assignment_id
4128: and pac.assignment_action_id = paa.assignment_action_id
4129: and pac.context_id = fc.context_id
4130: and fc.context_name = ''JURISDICTION_CODE''