eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_LTAX_IMP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 55: assignment_number per_all_assignments_f.assignment_number%type);

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;
58: g_imp_data_tbl_cnt number;
59: g_ass_data_tbl t_data_tbl;

Line 68: assignment_number per_all_assignments_f.assignment_number%type,

64: --
65: type t_ass_rec is record(
66: assignment_id number,
67: payroll_id number,
68: assignment_number per_all_assignments_f.assignment_number%type,
69: final_process_date date);
70: type t_ass_tbl is table of t_ass_rec index by binary_integer;
71: g_ass_ind_tbl t_ass_tbl;
72: --

Line 75: assignment_number per_all_assignments_f.assignment_number%type,

71: g_ass_ind_tbl t_ass_tbl;
72: --
73: type t_ass_amd_rec is record(
74: assignment_id number,
75: assignment_number per_all_assignments_f.assignment_number%type,
76: include_or_exclude hr_assignment_set_amendments.include_or_exclude%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: --

Line 701: l_assignment_id per_all_assignments_f.assignment_id%type;

697: is
698: --
699: l_proc varchar2(80) := c_package||'imp_file_data';
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;

Line 724: assignment_number per_all_assignments_f.assignment_number%type,

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;
728: l_ass_file_tbl t_ass_file_tbl;

Line 793: per_all_assignments_f pa,

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'
796: and hoi.org_information1 = 'JP_TAX_SWOT'
797: and hoi.organization_id = nvl(g_organization_id,hoi.organization_id)

Line 849: per_all_assignments_f pa,

845: select hasa.assignment_id,
846: pa.assignment_number,
847: hasa.include_or_exclude
848: from hr_assignment_set_amendments hasa,
849: per_all_assignments_f pa,
850: per_time_periods ptp
851: where hasa.assignment_set_id = g_assignment_set_id
852: and pa.assignment_id = hasa.assignment_id
853: and pa.effective_start_date <= g_effective_eom

Line 1449: l_assignment_id per_all_assignments_f.assignment_id%type;

1445: is
1446: --
1447: l_proc varchar2(80) := c_package||'get_ltxi_assignment';
1448: --
1449: l_assignment_id per_all_assignments_f.assignment_id%type;
1450: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1451: l_assignment_number per_all_assignments_f.assignment_number%type;
1452: l_regular_payment_date date;
1453: l_final_process_date date;

Line 1451: l_assignment_number per_all_assignments_f.assignment_number%type;

1447: l_proc varchar2(80) := c_package||'get_ltxi_assignment';
1448: --
1449: l_assignment_id per_all_assignments_f.assignment_id%type;
1450: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1451: l_assignment_number per_all_assignments_f.assignment_number%type;
1452: l_regular_payment_date date;
1453: l_final_process_date date;
1454: --
1455: cursor csr_ass

Line 1463: per_all_assignments_f pa,

1459: pa.assignment_number,
1460: ptp.regular_payment_date,
1461: greatest(ppos.actual_termination_date,nvl(ppos.final_process_date,ppos.actual_termination_date)) final_process_date
1462: from per_all_people_f pp,
1463: per_all_assignments_f pa,
1464: per_time_periods ptp,
1465: per_periods_of_service ppos
1466: where pp.business_group_id + 0 = g_business_group_id
1467: and pp.effective_start_date <= g_effective_eom

Line 1567: l_assignment_id per_all_assignments_f.assignment_id%type;

1563: l_proc varchar2(80) := c_package||'valid_ltxi_assignment';
1564: --
1565: l_valid boolean;
1566: --
1567: l_assignment_id per_all_assignments_f.assignment_id%type;
1568: l_include_or_exclude hr_assignment_set_amendments.include_or_exclude%type;
1569: --
1570: l_non_res_date date;
1571: l_res_date date;

Line 1802: l_assignment_id per_all_assignments_f.assignment_id%type;

1798: is
1799: --
1800: l_proc varchar2(80) := c_package||'valid_file_data';
1801: --
1802: l_assignment_id per_all_assignments_f.assignment_id%type;
1803: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1804: l_assignment_number per_all_assignments_f.assignment_number%type;
1805: l_regular_payment_date date;
1806: l_final_process_date date;

Line 1804: l_assignment_number per_all_assignments_f.assignment_number%type;

1800: l_proc varchar2(80) := c_package||'valid_file_data';
1801: --
1802: l_assignment_id per_all_assignments_f.assignment_id%type;
1803: l_payroll_id pay_all_payrolls_f.payroll_id%type;
1804: l_assignment_number per_all_assignments_f.assignment_number%type;
1805: l_regular_payment_date date;
1806: l_final_process_date date;
1807: --
1808: l_valid boolean;