DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 87: from pay_payroll_actions proc_ppa,

83: proc_paa.assignment_action_id,
84: proc_pjwa.itax_organization_id,
85: decode(proc_padr.address_id,null,proc_padc.town_or_city,proc_padr.town_or_city) town_or_city,
86: proc_pp.employee_number
87: from pay_payroll_actions proc_ppa,
88: pay_assignment_actions proc_paa,
89: pay_jp_wic_assacts_v proc_pjwa,
90: pay_all_payrolls_f proc_pap,
91: per_all_people_f proc_pp,

Line 140: pay_payroll_actions arch_ppa,

136: arch_pjia.employer_name itax_org_name,
137: arch_pjip.itax_organization_id itax_organization_id,
138: lpad(arch_pjip.employee_number,30,' ') employee_number
139: from
140: pay_payroll_actions arch_ppa,
141: pay_assignment_actions arch_paa,
142: pay_assignment_actions arch_ipaa,
143: pay_payroll_actions arch_ippa,
144: pay_jp_itax_person_v2 arch_pjip,

Line 143: pay_payroll_actions arch_ippa,

139: from
140: pay_payroll_actions arch_ppa,
141: pay_assignment_actions arch_paa,
142: pay_assignment_actions arch_ipaa,
143: pay_payroll_actions arch_ippa,
144: pay_jp_itax_person_v2 arch_pjip,
145: pay_jp_itax_arch_v2 arch_pjia,
146: (select arch_pjsn_act.organization_id,
147: arch_pjsn_act.district_code act_district_code,