APPS.PAY_JP_LTAX_IMP_PKG dependencies on PER_ADDRESSES

Line 53: i_district_code per_addresses.town_or_city%type,

49: i_ltax_2 number,
50: i_ltax_3 number,
51: i_ltax_4 number,
52: i_ltax_5 number,
53: i_district_code per_addresses.town_or_city%type,
54: assignment_id number,
55: assignment_number per_all_assignments_f.assignment_number%type);
56: type t_data_tbl is table of t_data_rec index by binary_integer;
57: g_imp_data_tbl t_data_tbl;

Line 81: district_code per_addresses.town_or_city%type,

77: type t_ass_amd_tbl is table of t_ass_amd_rec index by binary_integer;
78: g_ass_amd_ind_tbl t_ass_amd_tbl;
79: --
80: type t_imp_file_rec is record(
81: district_code per_addresses.town_or_city%type,
82: organization_id number,
83: swot_number pay_jp_swot_numbers.swot_number%type,
84: input_file_name pay_jp_swot_numbers.input_file_name%type);
85: type t_imp_file_tbl is table of t_imp_file_rec index by binary_integer;

Line 704: l_district_code_o per_addresses.town_or_city%type;

700: --
701: l_assignment_id per_all_assignments_f.assignment_id%type;
702: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
703: --
704: l_district_code_o per_addresses.town_or_city%type;
705: l_organization_id_o number;
706: l_input_file_name_o pay_jp_swot_numbers.input_file_name%type;
707: --
708: l_input_file_name pay_jp_swot_numbers.input_file_name%type;

Line 720: district_code per_addresses.town_or_city%type,

716: l_ass_amd_ind_tbl t_ass_amd_tbl;
717: --
718: type t_ass_file_rec is record(
719: assignment_id number,
720: district_code per_addresses.town_or_city%type,
721: organization_id number,
722: swot_number pay_jp_swot_numbers.swot_number%type,
723: input_file_name pay_jp_swot_numbers.input_file_name%type,
724: assignment_number per_all_assignments_f.assignment_number%type,

Line 791: per_addresses pad,

787: from hr_organization_information hoi,
788: hr_all_organization_units hou,
789: pay_jp_swot_numbers pjsn_act,
790: pay_jp_swot_numbers pjsn_rep,
791: per_addresses pad,
792: per_periods_of_service ppos,
793: per_all_assignments_f pa,
794: per_time_periods ptp
795: where hoi.org_information_context = 'CLASS'

Line 1487: from per_addresses pad,

1483: and ptp.regular_payment_date
1484: between ppos.date_start and nvl(greatest(ppos.actual_termination_date,nvl(ppos.final_process_date,ppos.actual_termination_date)),ptp.regular_payment_date)
1485: and exists(
1486: select null
1487: from per_addresses pad,
1488: pay_jp_swot_numbers pjsn_act,
1489: pay_jp_swot_numbers pjsn_rep,
1490: hr_all_organization_units hou,
1491: hr_organization_information hoi