DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_JP_ITAX_PERSON_V2

Line 468: pay_jp_itax_person_v2 pjip,

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,
471: pjsn_act.district_code act_district_code,
472: substrb(nvl(pjsn_act.report_district_code,pjsn_act.district_code),1,5) rep_district_code,

Line 868: pay_jp_itax_person_v2 pjip,

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,
872: pay_jp_itax_other2_v2 pjio2,

Line 1046: pay_jp_itax_person_v2 pjip,

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,
1050: pay_jp_itax_other2_v2 pjio2,

Line 1221: pay_jp_itax_person_v2 pjip,

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,
1225: pay_jp_itax_other2_v2 pjio2,

Line 1399: pay_jp_itax_person_v2 pjip,

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,
1403: pay_jp_itax_other_v pjio,

Line 1648: pay_jp_itax_person_v2 pjips

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
1652: and (to_number(to_char(pjip.effective_date,'YYYY')) < 2009