[Home] [Help]
386: pjwa.itax_yea_category,
387: pjwa.employment_category,
388: pjwa.actual_termination_date))) spr_term_valid
389: from pay_payroll_actions ppa,
390: pay_assignment_actions paa,
391: per_all_assignments_f pa,
392: pay_jp_wic_assacts_v pjwa
393: where ppa.effective_date
394: between fnd_date.canonical_to_date(''i_effective_soy'') and fnd_date.canonical_to_date(''i_effective_eoy'')
462: decode(sign(fnd_number.canonical_to_number(pjit.taxable_income) - to_number(''i_valid_term_taxable_amt'')),1,0,1))) spr_term_valid';
463: --
464: c_proc_arch_from_clause varchar2(32767)
465: := 'pay_payroll_actions ppa,
466: pay_assignment_actions paa,
467: pay_jp_itax_arch_v2 pjia,
468: pay_jp_itax_person_v2 pjip,
469: pay_jp_itax_tax_v pjit,
470: (select pjsn_act.organization_id,
676: pjwa.date_start,
677: pp.last_name||'' ''||pp.first_name full_name_kana,
678: pp.employee_number
679: from pay_payroll_actions ppa,
680: pay_assignment_actions paa,
681: pay_jp_wic_assacts_v pjwa,
682: pay_all_payrolls_f pap,
683: per_all_people_f pp,
684: per_addresses padr,
861: null new_pens_ins_prem';
862: --
863: c_data_arch_from_clause varchar2(32767)
864: := 'pay_payroll_actions ppa,
865: pay_assignment_actions paa,
866: pay_assignment_actions ipaa,
867: pay_payroll_actions ippa,
868: pay_jp_itax_person_v2 pjip,
869: pay_jp_itax_arch_v2 pjia,
862: --
863: c_data_arch_from_clause varchar2(32767)
864: := 'pay_payroll_actions ppa,
865: pay_assignment_actions paa,
866: pay_assignment_actions ipaa,
867: pay_payroll_actions ippa,
868: pay_jp_itax_person_v2 pjip,
869: pay_jp_itax_arch_v2 pjia,
870: pay_jp_itax_tax_v pjit,
1039: null new_pens_ins_prem';
1040: --
1041: c_data_arch_from_clause_2009 varchar2(32767)
1042: := 'pay_payroll_actions ppa,
1043: pay_assignment_actions paa,
1044: pay_assignment_actions ipaa,
1045: pay_payroll_actions ippa,
1046: pay_jp_itax_person_v2 pjip,
1047: pay_jp_itax_arch_v2 pjia,
1040: --
1041: c_data_arch_from_clause_2009 varchar2(32767)
1042: := 'pay_payroll_actions ppa,
1043: pay_assignment_actions paa,
1044: pay_assignment_actions ipaa,
1045: pay_payroll_actions ippa,
1046: pay_jp_itax_person_v2 pjip,
1047: pay_jp_itax_arch_v2 pjia,
1048: pay_jp_itax_tax_v pjit,
1214: null new_pens_ins_prem';
1215: --
1216: c_data_arch_from_clause_2011 varchar2(32767)
1217: := 'pay_payroll_actions ppa,
1218: pay_assignment_actions paa,
1219: pay_assignment_actions ipaa,
1220: pay_payroll_actions ippa,
1221: pay_jp_itax_person_v2 pjip,
1222: pay_jp_itax_arch_v2 pjia,
1215: --
1216: c_data_arch_from_clause_2011 varchar2(32767)
1217: := 'pay_payroll_actions ppa,
1218: pay_assignment_actions paa,
1219: pay_assignment_actions ipaa,
1220: pay_payroll_actions ippa,
1221: pay_jp_itax_person_v2 pjip,
1222: pay_jp_itax_arch_v2 pjia,
1223: pay_jp_itax_tax_v pjit,
1392: fnd_number.canonical_to_number(tax1.new_pen_ins_prem) new_pens_ins_prem';
1393: --
1394: c_data_arch_from_clause_2012 varchar2(32767)
1395: := 'pay_payroll_actions ppa,
1396: pay_assignment_actions paa,
1397: pay_assignment_actions ipaa,
1398: pay_payroll_actions ippa,
1399: pay_jp_itax_person_v2 pjip,
1400: pay_jp_itax_arch_v2 pjia,
1393: --
1394: c_data_arch_from_clause_2012 varchar2(32767)
1395: := 'pay_payroll_actions ppa,
1396: pay_assignment_actions paa,
1397: pay_assignment_actions ipaa,
1398: pay_payroll_actions ippa,
1399: pay_jp_itax_person_v2 pjip,
1400: pay_jp_itax_arch_v2 pjia,
1401: pay_jp_itax_tax_v pjit,
1643: and pjip.effective_date
1644: between g_effective_soy and g_effective_eoy
1645: and exists(
1646: select null
1647: from pay_assignment_actions paa,
1648: pay_jp_itax_person_v2 pjips
1649: where paa.payroll_action_id = ppa.payroll_action_id
1650: and pjips.action_context_id = paa.assignment_action_id
1651: and pjips.itax_organization_id = hoi.organization_id
2294: end if;
2295: --
2296: if l_ass_valid then
2297: --
2298: select pay_assignment_actions_s.nextval
2299: into l_spr_assignment_action_id
2300: from dual;
2301: --
2302: hr_nonrun_asact.insact(
5593: ----
5594: -- p_sqlstr :=
5595: -- 'select paa.rowid
5596: -- from pay_payroll_actions ppa,
5597: -- pay_assignment_actions paa
5598: -- where ppa.payroll_action_id = :pactid
5599: -- and paa.payroll_action_id = ppa.payroll_action_id';
5600: ----
5601: -- p_length := lengthb(p_sqlstr);