APPS.PAY_JP_SPR_EFILE_PKG dependencies on PER_ADDRESSES

Line 32: g_district_code per_addresses.town_or_city%type;

28: g_effective_eoy date;
29: g_effective_yyyy number;
30: g_business_group_id number;
31: g_legislation_code per_business_groups.legislation_code%type;
32: g_district_code per_addresses.town_or_city%type;
33: g_organization_id number;
34: g_assignment_set_id number;
35: g_request_id number;
36: g_file_split varchar2(1);

Line 92: per_addresses proc_padr,

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,
92: per_addresses proc_padr,
93: per_addresses proc_padc
94: where nvl(pay_jp_spr_efile_pkg.g_arch_pact_exist,'N') = 'N'
95: and proc_ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
96: and proc_paa.payroll_action_id = proc_ppa.payroll_action_id

Line 93: per_addresses proc_padc

89: pay_jp_wic_assacts_v proc_pjwa,
90: pay_all_payrolls_f proc_pap,
91: per_all_people_f proc_pp,
92: per_addresses proc_padr,
93: per_addresses proc_padc
94: where nvl(pay_jp_spr_efile_pkg.g_arch_pact_exist,'N') = 'N'
95: and proc_ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
96: and proc_paa.payroll_action_id = proc_ppa.payroll_action_id
97: and proc_pjwa.assignment_action_id = proc_paa.source_action_id