APPS.PAY_JP_LTAX_IMP_PKG dependencies on PAY_JP_SWOT_NUMBERS

Line 33: i_swot_number pay_jp_swot_numbers.swot_number%type,

29: --
30: type t_data_rec is record(
31: file_id number,
32: line number,
33: i_swot_number pay_jp_swot_numbers.swot_number%type,
34: i_personal_number pay_element_entry_values_f.screen_entry_value%type,
35: i_employee_number per_all_people_f.employee_number%type,
36: i_address varchar2(800),
37: i_address_kana varchar2(800),

Line 83: swot_number pay_jp_swot_numbers.swot_number%type,

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;
86: g_imp_file_ind_tbl t_imp_file_tbl;
87: --

Line 84: input_file_name pay_jp_swot_numbers.input_file_name%type);

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;
86: g_imp_file_ind_tbl t_imp_file_tbl;
87: --
88: type t_mth_rec is record(

Line 268: p_swot_number in pay_jp_swot_numbers.swot_number%type)

264: -- -------------------------------------------------------------------------
265: function default_file_name(
266: p_district_code in varchar2,
267: p_organization_id in number,
268: p_swot_number in pay_jp_swot_numbers.swot_number%type)
269: return varchar2
270: is
271: --
272: l_file_name varchar2(80);

Line 706: l_input_file_name_o pay_jp_swot_numbers.input_file_name%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;
709: l_file_line number;
710: --

Line 708: l_input_file_name pay_jp_swot_numbers.input_file_name%type;

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;
709: l_file_line number;
710: --
711: l_ass_id_tbl t_num_tbl;
712: l_ass_id_tbl_cnt number;

Line 722: swot_number pay_jp_swot_numbers.swot_number%type,

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,
725: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type,
726: regular_payment_date date);

Line 723: input_file_name pay_jp_swot_numbers.input_file_name%type,

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,
725: include_or_exclude hr_assignment_set_amendments.include_or_exclude%type,
726: regular_payment_date date);
727: type t_ass_file_tbl is table of t_ass_file_rec index by binary_integer;

Line 750: pay_jp_swot_numbers pjsn_act,

746: pjsn_rep.swot_number,
747: pjsn_rep.input_file_name
748: from hr_organization_information hoi,
749: hr_all_organization_units hou,
750: pay_jp_swot_numbers pjsn_act,
751: pay_jp_swot_numbers pjsn_rep
752: where hoi.org_information_context = 'CLASS'
753: and hoi.org_information1 = 'JP_TAX_SWOT'
754: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)

Line 751: pay_jp_swot_numbers pjsn_rep

747: pjsn_rep.input_file_name
748: from hr_organization_information hoi,
749: hr_all_organization_units hou,
750: pay_jp_swot_numbers pjsn_act,
751: pay_jp_swot_numbers pjsn_rep
752: where hoi.org_information_context = 'CLASS'
753: and hoi.org_information1 = 'JP_TAX_SWOT'
754: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)
755: and hou.organization_id = hoi.organization_id

Line 789: pay_jp_swot_numbers pjsn_act,

785: pjsn_rep.input_file_name,
786: ptp.regular_payment_date
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,

Line 790: pay_jp_swot_numbers pjsn_rep,

786: ptp.regular_payment_date
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

Line 1488: pay_jp_swot_numbers pjsn_act,

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
1492: where pad.person_id = pp.person_id

Line 1489: pay_jp_swot_numbers pjsn_rep,

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
1492: where pad.person_id = pp.person_id
1493: and pad.address_type in ('JP_C','JP_R')