[Home] [Help]
17: REM vbanner 28-jun-04 115.6 GSCC changes (dbdrv etc).
18: REM vbanner 28-jun-04 115.7 Further GSCC changes (to_date etc).
19: REM ynegoro 19-JUL-04 115.8 3730282 Added substr(p_location_name,1,80)
20: REM to insert a record into
21: REM pay_us_rpt_totals
22: REM Changed promotion procedure
23: REM ynegoro 28-SEP-04 115.9 3894120 Changed the length of fein
24: REM in TYPE establishment
25: REM ynegoro 05-OCT-04 115.10 3886008 Added l_hours_worked is NULL
843: est_infm(l_est_count).location_name:=p_location_name;
844: est_infm(l_est_count).est_flag:='Y';
845:
846: -- Bug# 5982927
847: update pay_us_rpt_totals
848: set gre_name = p_fein,
849: location_name = p_location_name
850: where session_id = est_id.entity_id
851: and business_group_id = l_seq_num;
1069: IF i = 2 then
1070: l_ethnic_group_code:=6;
1071: END If;
1072:
1073: INSERT INTO pay_us_rpt_totals
1074: ( session_id,
1075: business_group_id,
1076: location_id,
1077: location_name,
2013:
2014: hr_utility.trace('=============================== job_race_insert==================================');
2015: FOR job_code in eeo1_job_code LOOP
2016: FOR i in 0 .. 8 LOOP
2017: INSERT INTO pay_us_rpt_totals
2018: (session_id,
2019: business_group_id,
2020: attribute1,
2021: attribute4,
2032: END LOOP;
2033:
2034: FOR i in 1 ..4 LOOP
2035: FOR job_code in eeo1_job_code LOOP
2036: INSERT INTO pay_us_rpt_totals
2037: (session_id,
2038: business_group_id,
2039: attribute1,
2040: value14,