[Home] [Help]
788: , asg.effective_start_date start_date
789: , least(pcf.effective_end_date, c_end_date) end_date
790: from pay_assignment_actions paa
791: ,per_all_assignments_f asg
792: ,per_contracts_f pcf
793: ,hr_organization_information org_est
794: where paa.assignment_action_id = g_assign_action_id
795: and org_est.org_information1 = p_org_id
796: and asg.person_id = p_person_id
999: From per_all_assignments_f asg
1000: ,pay_assignment_actions paa
1001: , per_jobs pj
1002: , per_all_people_f paf
1003: , per_contracts_f pc
1004: , HR_SOFT_CODING_KEYFLEX sck
1005: , hr_organization_information org_est
1006: , per_collective_agreements pca
1007: Where paa.assignment_action_id = g_assign_action_id
1274: l_siret_number VARCHAR2(10);
1275: l_estab_id per_all_assignments_f.establishment_id%type;
1276: l_element_entry_id pay_element_entries_f.element_entry_id%type;
1277: l_contract_type VARCHAR2(50);
1278: l_contract_type_1 per_contracts_f.type%type;
1279: l_prof_code HR_SOFT_CODING_KEYFLEX.segment16%type;
1280: l_border_worker HR_SOFT_CODING_KEYFLEX.segment12%type;
1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%type;
1282: l_act_type per_contracts_f.type%type;
1278: l_contract_type_1 per_contracts_f.type%type;
1279: l_prof_code HR_SOFT_CODING_KEYFLEX.segment16%type;
1280: l_border_worker HR_SOFT_CODING_KEYFLEX.segment12%type;
1281: l_detache HR_SOFT_CODING_KEYFLEX.segment14%type;
1282: l_act_type per_contracts_f.type%type;
1283: l_norm_hours NUMBER;
1284: l_frequency per_all_assignments_f.frequency%type;
1285: l_employment_cat per_all_assignments_f.employment_category%type;
1286: l_person_number per_all_people_f.employee_number%type;
1304: l_id2 VARCHAR2(30);
1305:
1306: --Used in determining reason code 21....
1307: l_21_con_old Varchar2(250); --contract category-- proration is feasible
1308: l_21_con_status per_contracts_f.status%type; --contract status -proration is feasible
1309: l_21_status_old Varchar2(250); --contract status-- proration is feasible
1310: l_21_cat_old Varchar2(250); -- employee category -- proration feasible only if its parttime.
1311: l_21_cipdz_old varchar2(250); --CIPDZ Value -- proration feasible only if its parttime.
1312: l_21_ptype_old Varchar2(250); --Process Type -- proration is feasible.
1341: l_num_hrs_emp Number;
1342: l_num_hrs_latest Number;
1343: l_mth_023 varchar2(2);
1344: -- variables added for time analysis changes
1345: l_ctr_frequency per_contracts_f.ctr_information13%type;
1346: l_norm_ctr_hours per_contracts_f.ctr_information11%type;
1347: l_ctr_units per_contracts_f.ctr_information12%type;
1348: l_023_ss_base NUMBER;
1349: l_023_ss_base_retro NUMBER;
1342: l_num_hrs_latest Number;
1343: l_mth_023 varchar2(2);
1344: -- variables added for time analysis changes
1345: l_ctr_frequency per_contracts_f.ctr_information13%type;
1346: l_norm_ctr_hours per_contracts_f.ctr_information11%type;
1347: l_ctr_units per_contracts_f.ctr_information12%type;
1348: l_023_ss_base NUMBER;
1349: l_023_ss_base_retro NUMBER;
1350: l_023_ss_disabled_base NUMBER;
1343: l_mth_023 varchar2(2);
1344: -- variables added for time analysis changes
1345: l_ctr_frequency per_contracts_f.ctr_information13%type;
1346: l_norm_ctr_hours per_contracts_f.ctr_information11%type;
1347: l_ctr_units per_contracts_f.ctr_information12%type;
1348: l_023_ss_base NUMBER;
1349: l_023_ss_base_retro NUMBER;
1350: l_023_ss_disabled_base NUMBER;
1351: l_023_ss_disabled_base_retro NUMBER;
1662: elsif l_21_con_old <> csr_contract_rec.contract_id THEN
1663: begin
1664: select status
1665: into l_21_con_status
1666: from per_contracts_f
1667: where contract_id = l_21_con_old
1668: and csr_contract_rec.start_date between effective_Start_date
1669: and effective_end_Date;
1670: exception