[Home] [Help]
1266: cursor csr_er_credit is
1267: select distinct 'ER Tax Credits' classification_name ,'FUTA CREDIT' balance_name ,
1268: pet.element_name element_name, prr.jurisdiction_code jurisdiction_code
1269: from pay_element_types_f pet,
1270: pay_run_results prr
1271: where l_effective_date between pet.effective_start_date and pet.effective_end_date
1272: and pet.element_name ='FUTA CREDIT'
1273: and prr.status in ('P','PA')
1274: and pet.element_type_id = prr.element_type_id
1475: pet.element_name element_name
1476: from pay_balance_types pbt,
1477: pay_element_types_f pet,
1478: pay_element_classifications pec,
1479: pay_run_results prr
1480: where pec.classification_name ='Employer Liabilities'
1481: and pec.legislation_code ='US'
1482: and pet.classification_id = pec.classification_id
1483: and pet.business_group_id = l_business_group_id
1946: and exists (
1947: select 'Y'
1948: from pay_run_result_values rrv,
1949: pay_input_values_F iv,
1950: pay_run_results rr
1951: where nvl(rrv.result_value,0) <> to_char(0)
1952: and iv.input_value_id = rrv.input_value_id
1953: and iv.name = 'Pay Value'
1954: and rr.run_result_id = rrv.run_result_id
2125: pay_assignment_actions paa,
2126: per_all_assignments_f paf,
2127: pay_us_emp_fed_tax_rules_F pftr,
2128: pay_us_states pst,
2129: pay_run_results prr
2130: where pec.classification_name ='Employer Taxes'
2131: and pec.legislation_code ='US'
2132: and pet.classification_id = pec.classification_id
2133: and l_effective_date between pet.effective_start_date
2463: l_state_liab_view_name := 'PAY_US_STATE_LIABILITIES_V';
2464: l_futa_where := ' prr.status in ('||'''P'''||','||'''PA'''||')
2465: and pet.element_type_id = prr.element_type_id
2466: and prr.assignment_action_id = ';
2467: l_futa_from := ' pay_run_results prr ';
2468:
2469: l_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
2470: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')
2471: and prr.assignment_action_id = ';
2468:
2469: l_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
2470: and prr.status in (' || '''P''' || ', ' || '''PA''' || ')
2471: and prr.assignment_action_id = ';
2472: l_er_liab_from := ' pay_run_results prr ';
2473:
2474: l_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
2475: and prr.assignment_action_id = ';
2476: l_wc_er_liab_from := ' pay_run_results prr ';
2472: l_er_liab_from := ' pay_run_results prr ';
2473:
2474: l_wc_er_liab_where := ' prr.element_type_id +0 = pet.element_type_id
2475: and prr.assignment_action_id = ';
2476: l_wc_er_liab_from := ' pay_run_results prr ';
2477: l_asg_flag := 'N';
2478: open sel_aaid (to_number(pactid),chnkno);
2479: loop
2480: fetch sel_aaid into l_start_date,