[Home] [Help]
385: pjwa.itax_category,
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
461: to_number(decode(to_char(pjip.actual_termination_date,''YYYY/MM/DD''),null,0,
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,
675: pjwa.actual_termination_date,
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,
860: null new_care_med_prem,
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,
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,
871: pay_jp_itax_other_v pjio,
1038: null new_care_med_prem,
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,
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,
1049: pay_jp_itax_other_v pjio,
1213: null new_care_med_prem,
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,
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,
1224: pay_jp_itax_other_v pjio,
1391: fnd_number.canonical_to_number(tax1.care_med_ins_prem) new_care_med_prem,
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,
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,
1402: pay_jp_itax_tax_v2 tax1,
1606: ppa.effective_date,
1607: ppa.legislative_parameters,
1608: pbg.legislation_code,
1609: ppa.request_id
1610: from pay_payroll_actions ppa,
1611: per_business_groups_perf pbg
1612: where ppa.payroll_action_id = p_payroll_action_id
1613: and pbg.business_group_id = ppa.business_group_id;
1614: --
1628: and hou.date_from <= g_effective_eoy
1629: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy
1630: and not exists(
1631: select null
1632: from pay_payroll_actions ppa,
1633: pay_jp_itax_pact_v2 pjip
1634: where ppa.business_group_id + 0 = g_business_group_id
1635: and ppa.effective_date
1636: between g_effective_soy and g_effective_eoy
1923: p_sqlstr :=
1924: 'select /*+ ORDERED
1925: INDEX(PPOS PER_PERIODS_OF_SERVICE_N3) */
1926: distinct ppos.person_id
1927: from pay_payroll_actions ppa,
1928: per_all_people_f pp,
1929: per_periods_of_service ppos
1930: where ppa.payroll_action_id = :payroll_action_id
1931: and pp.business_group_id = ppa.business_group_id + 0
5002: --
5003: cursor csr_action
5004: is
5005: select ppa.payroll_action_id
5006: from pay_payroll_actions ppa
5007: where ppa.request_id = p_request_id
5008: and ppa.action_type = 'X'
5009: and ppa.report_type = 'JP_SPR_EFILE'
5010: and ppa.report_qualifier = 'JP'
5592: -- end if;
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: ----