[Home] [Help]
3681: l_end_date DATE;
3682: l_seq_no VARCHAR2(50);
3683: l_tax_unit_id NUMBER;
3684: l_payroll_type VARCHAR2(80);
3685: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
3686: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
3687: l_risk_cover_flag hr_lookups.lookup_type%TYPE;
3688: l_date DATE;
3689: l_prev_corr_year VARCHAR2(100); --10100628
3682: l_seq_no VARCHAR2(50);
3683: l_tax_unit_id NUMBER;
3684: l_payroll_type VARCHAR2(80);
3685: l_business_group_id hr_all_organization_units.business_group_id%TYPE;
3686: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
3687: l_risk_cover_flag hr_lookups.lookup_type%TYPE;
3688: l_date DATE;
3689: l_prev_corr_year VARCHAR2(100); --10100628
3690: l_er_only VARCHAR2(10); --10100628
3767: IS
3768: -- DECLARE LOCAL VARIABLES
3769: l_ovn pay_action_information.object_version_number%type;
3770: l_action_info_id pay_action_information.action_information_id%type;
3771: l_business_group_id hr_all_organization_units.business_group_id%type;
3772: l_seq_no VARCHAR2(50);
3773: l_emp_total number;
3774: l_tax_unit_id NUMBER;
3775: l_payroll_type VARCHAR2(80);
3833: l_exception_flag VARCHAR2(1);
3834: l_awf VARCHAR2(1);
3835: l_tax_ref_no hr_organization_information.org_information1%TYPE;
3836: l_tax_rep_name hr_organization_information.org_information3%TYPE;
3837: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
3838: --#
3839: --
3840: --
3841: --csr_employer_info_rec csr_employer_info%ROWTYPE;
3963: IS
3964: -- DECLARE LOCAL VARIABLES
3965: l_ovn pay_action_information.object_version_number%type;
3966: l_action_info_id pay_action_information.action_information_id%type;
3967: l_business_group_id hr_all_organization_units.business_group_id%type;
3968: l_start_date DATE;
3969: l_end_date DATE;
3970: l_seq_no VARCHAR2(50);
3971: l_emp_total number;
4031: l_exception_flag VARCHAR2(1);
4032: l_awf VARCHAR2(1);
4033: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4034: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4035: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4036: --#
4037: --
4038: --
4039: --csr_employer_info_rec csr_employer_info%ROWTYPE;
4128: IS
4129: -- DECLARE LOCAL VARIABLES
4130: l_ovn pay_action_information.object_version_number%type;
4131: l_action_info_id pay_action_information.action_information_id%type;
4132: l_business_group_id hr_all_organization_units.business_group_id%type;
4133: l_start_date DATE;
4134: l_end_date DATE;
4135: l_seq_no VARCHAR2(50);
4136: l_emp_total number;
4433: l_exception_flag VARCHAR2(1);
4434: l_awf VARCHAR2(1);
4435: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4436: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4437: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4438: --#
4439: --
4440: CURSOR csr_get_pactid IS
4441: SELECT DISTINCT paa1.payroll_action_id
7258: AND hou.organization_id = hoi.organization_id
7259: AND hou.organization_id = c_employer_id;
7260: --
7261: l_actid NUMBER;
7262: l_legal_employer hr_all_organization_units.organization_id%type;
7263: l_start_date DATE;
7264: l_end_date DATE;
7265: l_business_group_id NUMBER;
7266: l_chk_assignment_id NUMBER;
7266: l_chk_assignment_id NUMBER;
7267: l_payroll_type VARCHAR2(10);
7268: l_seq_no VARCHAR2(15);
7269: l_paid_flag VARCHAR2(15);
7270: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
7271: --
7272: CURSOR csr_persons(stperson NUMBER
7273: ,endperson NUMBER
7274: ,c_start_date DATE