[Home] [Help]
826: l_period_recon := NVL(get_parameter('PERIOD_RECON',leg_param),'02');
827:
828: select last_day(decode(l_period_recon, '02', to_date(l_tax_year||'-02-01','yyyy-mm-dd'), '08', to_date(l_tax_year-1 ||'-08-01','yyyy-mm-dd')))
829: into l_period_recon_last_date
830: from dual;
831:
832: hr_utility.set_location(l_proc,10);
833:
834: if l_cert_type = '1' then
907: -- Create one assignment action for every assignment
908: hr_utility.set_location('Archiving for assignment_id '||asgrec.assignment_id, 50);
909: select pay_assignment_actions_s.nextval
910: into lockingactid
911: from dual;
912:
913: -- Insert assignment into pay_assignment_actions
914: hr_nonrun_asact.insact
915: (
1259: l_period_recon := NVL(get_parameter('PERIOD_RECON',l_leg_param),'02');
1260:
1261: select last_day(decode(l_period_recon, '02', to_date(l_tax_year||'-02-01','yyyy-mm-dd'), '08', to_date(l_tax_year-1 ||'-08-01','yyyy-mm-dd')))
1262: into l_period_recon_last_date
1263: from dual;
1264:
1265: if l_period_recon = '08' then
1266:
1267: --Check if the assignment is terminated or ended
1379: select decode (sign (add_months (to_date (l_archive_tab(0).act_info11, 'YYYYMMDD'), 780)
1380: - to_date (l_archive_tab(0).act_info4 || '-03-01', 'yyyy-mm-dd')-1), 1
1381: , 'B', 'A')
1382: into l_65Years_age
1383: from dual;
1384: hr_utility.set_location('l_65Years_age:'||l_65Years_age,30);
1385:
1386: ------------------------------------------------------------------------
1387: -- 3. Populate t_dir_num with all directive numbers for this assignment in this tax year
2772: l_period_recon := NVL(get_parameter('PERIOD_RECON', l_leg_param),'02');
2773:
2774: select last_day(decode(l_period_recon, '02', to_date(l_tax_year||'-02-01','yyyy-mm-dd'), '08', to_date(l_tax_year-1 ||'-08-01','yyyy-mm-dd')))
2775: into l_period_recon_last_date
2776: from dual;
2777:
2778: fnd_file.put_line (fnd_file.LOG, '$$$ l_period_recon_last_date '||l_period_recon_last_date);
2779: -- 9877034 ends
2780:
2918: select trim(to_char(trunc( (l_date_employed_to - l_date_employed_from + 1)/
2919: (( l_tax_year_end_date - l_tax_year_start_date +1)/l_total_tax_periods)
2920: ,4),'990D9999'))
2921: into l_pay_periods_worked
2922: from dual;
2923: end if;
2924: end if;
2925:
2926: hr_utility.set_location(l_proc,30);
4329: null,
4330: null,
4331: null,
4332: 'TRUE')
4333: from dual;
4334:
4335: l_def_bal_id number;
4336: l_bal_val number;
4337: l_bal_id number;