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.GHR_PAY_CALC dependencies on STANDARD

Line 129: -- 0 if it is the 'standard default' table otherwise 6

125: --
126: END get_user_table_id;
127: --
128: -- Depenending on the user table associated with the position this function will return
129: -- 0 if it is the 'standard default' table otherwise 6
130: FUNCTION get_default_prd (p_position_id IN NUMBER
131: ,p_effective_date IN DATE)
132: RETURN VARCHAR2 IS
133: l_user_table_id pay_user_tables.user_table_id%TYPE;

Line 145: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN

141: IF l_user_table_id IS NOT NULL THEN
142: --
143: l_user_table_name := ghr_pay_calc.get_user_table_name(l_user_table_id);
144: -- Note: Must have a table name if we have a table_id
145: IF l_user_table_name = ghr_pay_calc.l_standard_table_name THEN
146: RETURN('0');
147: ELSE
148: RETURN('6');
149: END IF;

Line 424: -- PA PH /2087 - standard rounding to 2dp

420: --
421: -- This function converts a given amount from one pay_basis to another.
422: -- Currently we only know how to convert the following
423: -- FROM TO
424: -- PA PH /2087 - standard rounding to 2dp
425: -- PA BW /2087 *80 - standard rounding to 2dp
426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP

Line 425: -- PA BW /2087 *80 - standard rounding to 2dp

421: -- This function converts a given amount from one pay_basis to another.
422: -- Currently we only know how to convert the following
423: -- FROM TO
424: -- PA PH /2087 - standard rounding to 2dp
425: -- PA BW /2087 *80 - standard rounding to 2dp
426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp

Line 426: -- PH PA *2087 - standard rounding to whole number

422: -- Currently we only know how to convert the following
423: -- FROM TO
424: -- PA PH /2087 - standard rounding to 2dp
425: -- PA BW /2087 *80 - standard rounding to 2dp
426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp

Line 427: -- BW PA /80 *2087 - standard rounding to whole number

423: -- FROM TO
424: -- PA PH /2087 - standard rounding to 2dp
425: -- PA BW /2087 *80 - standard rounding to 2dp
426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp
431: -- PD PA *261 - standard rounding to whole number

Line 429: -- PA PD /261 - standard rounding to 2dp

425: -- PA BW /2087 *80 - standard rounding to 2dp
426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp
431: -- PD PA *261 - standard rounding to whole number
432: -- PM PA *12 - standard rounding to whole number
433: l_conv_amount NUMBER;

Line 430: -- PA PM /12 - standard rounding to 2dp

426: -- PH PA *2087 - standard rounding to whole number
427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp
431: -- PD PA *261 - standard rounding to whole number
432: -- PM PA *12 - standard rounding to whole number
433: l_conv_amount NUMBER;
434: BEGIN

Line 431: -- PD PA *261 - standard rounding to whole number

427: -- BW PA /80 *2087 - standard rounding to whole number
428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp
431: -- PD PA *261 - standard rounding to whole number
432: -- PM PA *12 - standard rounding to whole number
433: l_conv_amount NUMBER;
434: BEGIN
435: IF p_in_pay_basis = p_out_pay_basis THEN

Line 432: -- PM PA *12 - standard rounding to whole number

428: -- Added for TSP
429: -- PA PD /261 - standard rounding to 2dp
430: -- PA PM /12 - standard rounding to 2dp
431: -- PD PA *261 - standard rounding to whole number
432: -- PM PA *12 - standard rounding to whole number
433: l_conv_amount NUMBER;
434: BEGIN
435: IF p_in_pay_basis = p_out_pay_basis THEN
436: RETURN(p_amount);

Line 811: --------------------------- ----------------------------------

807: RAISE;
808: --
809: END get_pay_table_value;
810: --
811: --------------------------- ----------------------------------
812: FUNCTION get_standard_pay_table_value (p_pay_plan IN VARCHAR2
813: ,p_grade_or_level IN VARCHAR2
814: ,p_step_or_rate IN VARCHAR2
815: ,p_effective_date IN DATE)

Line 812: FUNCTION get_standard_pay_table_value (p_pay_plan IN VARCHAR2

808: --
809: END get_pay_table_value;
810: --
811: --------------------------- ----------------------------------
812: FUNCTION get_standard_pay_table_value (p_pay_plan IN VARCHAR2
813: ,p_grade_or_level IN VARCHAR2
814: ,p_step_or_rate IN VARCHAR2
815: ,p_effective_date IN DATE)
816: RETURN NUMBER IS

Line 827: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name

823: FROM pay_user_column_instances_f cin
824: ,pay_user_rows_f urw
825: ,pay_user_columns col
826: ,pay_user_tables utb
827: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name
828: AND col.user_table_id = utb.user_table_id
829: AND col.user_column_name = p_step_or_rate
830: AND urw.user_table_id = utb.user_table_id
831: AND urw.row_low_range_or_name = p_pay_plan||'-'||p_grade_or_level

Line 841: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date

837: FOR cur_default_pay_rec IN cur_default_pay LOOP
838: l_pay_plan_value := ROUND(cur_default_pay_rec.basic_pay,2);
839: l_record_found := TRUE;
840: IF l_pay_plan_value IS NULL THEN
841: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date
842: hr_utility.set_message(8301, 'GHR_38252_NULL_PAY_PLAN_VALUE');
843: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name );
844: hr_utility.set_message_token('STEP',p_step_or_rate);
845: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

Line 843: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name );

839: l_record_found := TRUE;
840: IF l_pay_plan_value IS NULL THEN
841: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date
842: hr_utility.set_message(8301, 'GHR_38252_NULL_PAY_PLAN_VALUE');
843: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name );
844: hr_utility.set_message_token('STEP',p_step_or_rate);
845: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
846: hr_utility.set_message_token('GRADE',p_grade_or_level);
847: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 854: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date

850: END IF;
851: END LOOP;
852: --
853: IF NOT l_record_found THEN
854: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date
855: hr_utility.set_message(8301, 'GHR_38253_NO_PAY_PLAN_VALUE');
856: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name);
857: hr_utility.set_message_token('STEP',p_step_or_rate);
858: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);

Line 856: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name);

852: --
853: IF NOT l_record_found THEN
854: -- Set tokens to give name of pay table(standard), pay plan, grade, step and date
855: hr_utility.set_message(8301, 'GHR_38253_NO_PAY_PLAN_VALUE');
856: hr_utility.set_message_token('PAY_TABLE_NAME',ghr_pay_calc.l_standard_table_name);
857: hr_utility.set_message_token('STEP',p_step_or_rate);
858: hr_utility.set_message_token('PAY_PLAN',p_pay_plan);
859: hr_utility.set_message_token('GRADE',p_grade_or_level);
860: -- hr_utility.set_message_token('EFF_DATE',TO_CHAR(p_effective_date,'DD-MON-YYYY') );

Line 867: END get_standard_pay_table_value;

863: ELSE
864: RETURN(l_pay_plan_value);
865: END IF;
866: --
867: END get_standard_pay_table_value;
868: --
869: -- This function is used to determine if the given position is a 'LEO'
870: -- The definition of a LEO is the 'LEO Position Indicator' on information type 'GHR_US_POS_GRP2'
871: -- is 1 or 2

Line 934: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

930:
931: CURSOR get_std_user_table_id IS
932: SELECT utb.user_table_id
933: FROM pay_user_tables utb
934: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
935:
936: BEGIN
937: -- First get the id of standard pay table for later use
938: FOR c_rec IN get_std_user_table_id LOOP

Line 937: -- First get the id of standard pay table for later use

933: FROM pay_user_tables utb
934: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
935:
936: BEGIN
937: -- First get the id of standard pay table for later use
938: FOR c_rec IN get_std_user_table_id LOOP
939: l_std_user_table_id := c_rec.user_table_id;
940: END LOOP;
941: --

Line 1193: ELSIF ghr_pay_calc.get_user_table_name(l_user_table_id) NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name)

1189: l_locality_adj := 0;
1190: --Bug 4740036 Start
1191: --Bug 4740036 Start
1192:
1193: ELSIF ghr_pay_calc.get_user_table_name(l_user_table_id) NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name)
1194: AND l_pay_plan in ('GG','GS')
1195: AND p_pay_calc_data.pay_rate_determinant IN ('6','E','F')
1196: AND ghr_pay_calc.LEO_position (l_dummy
1197: ,p_pay_calc_data.position_id

Line 1202: FOR c_rec IN c_user_table_id(ghr_pay_calc.l_standard_table_name) LOOP

1198: ,l_dummy
1199: ,l_dummy
1200: ,p_pay_calc_data.effective_date) THEN
1201: hr_utility.set_location('AB p_pay_calc_data.pay_rate_determinant ' || p_pay_calc_data.pay_rate_determinant,99);
1202: FOR c_rec IN c_user_table_id(ghr_pay_calc.l_standard_table_name) LOOP
1203: l_std_user_table_id := c_rec.user_table_id;
1204: END LOOP;
1205: hr_utility.set_location('AB l_std_user_table_id ' || l_std_user_table_id,99);
1206: IF p_pay_calc_data.pay_rate_determinant = '6' THEN

Line 1338: -- the standard table 'GS'

1334: IF l_pay_plan NOT IN ('GM','GH') THEN
1335: --
1336: -- Sundar 3294560 If Pay plan is 'GG' take from 'GG' else take from GS.
1337: -- Pay Plan should be either GG or GS, if not in 'GM', 'GH'. If not, then assign
1338: -- the standard table 'GS'
1339: IF l_pay_plan NOT IN ('GG','GS') THEN
1340: l_pay_plan := 'GS';
1341: END IF; -- IF l_pay_plan NOT IN ('GG','GS')
1342:

Line 1343: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1339: IF l_pay_plan NOT IN ('GG','GS') THEN
1340: l_pay_plan := 'GS';
1341: END IF; -- IF l_pay_plan NOT IN ('GG','GS')
1342:
1343: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1344: ,p_pay_calc_data.grade_or_level
1345: ,NVL(p_pay_calc_out_data.out_step_or_rate,p_pay_calc_data.step_or_rate)
1346: ,p_pay_calc_data.effective_date);
1347: -- End Bug 3294560

Line 1358: -- Pay Plan should be either GG or GS, if not in 'GM', 'GH'. If not, then -- the standard table 'GS'

1354: --
1355: IF l_pay_plan NOT IN ('GM','GH') THEN
1356: --
1357: -- Sundar 3294560 If Pay plan is 'GG' take from 'GG' else take from GS.
1358: -- Pay Plan should be either GG or GS, if not in 'GM', 'GH'. If not, then -- the standard table 'GS'
1359: IF l_pay_plan NOT IN ('GG','GS','GL') THEN
1360: l_pay_plan := 'GS';
1361: END IF; -- IF l_pay_plan NOT IN ('GG','GS','GL')
1362:

Line 1421: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1417:
1418: -- Bug 3294560 Hard coding of 'GS' replaced with l_pay_plan
1419: IF p_retained_grade.temp_step IS NOT NULL THEN
1420:
1421: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1422: ,p_pay_calc_data.grade_or_level
1423: ,l_new_step_or_rate
1424: ,p_pay_calc_data.effective_date);
1425: ELSE

Line 1426: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1422: ,p_pay_calc_data.grade_or_level
1423: ,l_new_step_or_rate
1424: ,p_pay_calc_data.effective_date);
1425: ELSE
1426: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1427: ,p_retained_grade.grade_or_level
1428: ,l_new_step_or_rate
1429: ,p_pay_calc_data.effective_date);
1430: END IF;

Line 1434: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1430: END IF;
1431: ELSE
1432: --- Bug 1953725 End
1433: if p_retained_grade.temp_step is not null then
1434: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1435: ,p_pay_calc_data.grade_or_level
1436: ,p_retained_grade.temp_step
1437: ,p_pay_calc_data.effective_date);
1438: else

Line 1439: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1435: ,p_pay_calc_data.grade_or_level
1436: ,p_retained_grade.temp_step
1437: ,p_pay_calc_data.effective_date);
1438: else
1439: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1440: ,p_retained_grade.grade_or_level
1441: ,p_retained_grade.step_or_rate
1442: ,p_pay_calc_data.effective_date);
1443: end if;

Line 2794: l_prd_d_pay_amount := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => l_pay_plan

2790: l_pay_calc_out_data.open_localityadj_field := TRUE;
2791: end if;*/
2792: --Begin Bug# 7557159
2793: IF l_pay_plan='GS' AND l_pay_rate_determinant='D' THEN
2794: l_prd_d_pay_amount := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => l_pay_plan
2795: ,p_grade_or_level => l_grade_or_level
2796: ,p_step_or_rate => '10'
2797: ,p_effective_date => p_effective_date);
2798:

Line 3026: l_SPT_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan

3022: ,p_PT_eff_start_date => l_PT_o_eff_start_date
3023: ,p_PT_eff_end_date => l_PT_o_eff_end_date);
3024:
3025: hr_utility.set_location('l_PT_o_value ...'|| to_char(l_PT_o_value),5);
3026: l_SPT_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan
3027: ,p_grade_or_level => p_grade_or_level
3028: ,p_step_or_rate => p_step_or_rate
3029: ,p_effective_date => p_effective_date);
3030:

Line 3032: l_SPT_o_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan

3028: ,p_step_or_rate => p_step_or_rate
3029: ,p_effective_date => p_effective_date);
3030:
3031: hr_utility.set_location('l_SPT_value ...'|| to_char(l_SPT_value),5);
3032: l_SPT_o_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan
3033: ,p_grade_or_level => p_grade_or_level
3034: ,p_step_or_rate => p_step_or_rate
3035: ,p_effective_date => (l_PT_eff_start_date -1) );
3036:

Line 3111: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

3107:
3108: CURSOR get_std_user_table_id IS
3109: SELECT utb.user_table_id
3110: FROM pay_user_tables utb
3111: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3112:
3113: BEGIN
3114: hr_utility.set_location('Entering ...'|| l_proc,5);
3115: -- First get the id of standard pay table for later use

Line 3115: -- First get the id of standard pay table for later use

3111: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3112:
3113: BEGIN
3114: hr_utility.set_location('Entering ...'|| l_proc,5);
3115: -- First get the id of standard pay table for later use
3116: FOR c_rec IN get_std_user_table_id LOOP
3117: l_std_user_table_id := c_rec.user_table_id;
3118: END LOOP;
3119:

Line 3208: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN

3204: IF l_new_std_relative_rate > new_adj_basic_pay THEN
3205: new_adj_basic_pay := l_new_std_relative_rate;
3206: new_locality_adj := new_adj_basic_pay - l_new_basic_pay;
3207: ELSIF (l_new_basic_pay > new_adj_basic_pay) AND
3208: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN
3209: new_adj_basic_pay := l_new_basic_pay;
3210: new_locality_adj := 0;
3211: END IF;
3212:

Line 3405: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

3401:
3402: CURSOR get_std_user_table_id IS
3403: SELECT utb.user_table_id
3404: FROM pay_user_tables utb
3405: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3406:
3407: ----
3408: l_assignment_id per_assignments_f.assignment_id%type;
3409: l_value varchar2(60);

Line 3427: -- First get the id of standard pay table for later use

3423: BEGIN
3424: hr_utility.set_location('Entering ...'|| l_proc,5);
3425: g_gm_unadjd_basic_pay := NULL;
3426: gm_unadjusted_pay_flg := NULL;
3427: -- First get the id of standard pay table for later use
3428: FOR c_rec IN get_std_user_table_id LOOP
3429: l_std_user_table_id := c_rec.user_table_id;
3430: END LOOP;
3431:

Line 3582: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;

3578:
3579: CURSOR get_std_user_table_id IS
3580: SELECT utb.user_table_id
3581: FROM pay_user_tables utb
3582: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3583:
3584: ----
3585: l_assignment_id per_assignments_f.assignment_id%type;
3586: l_value varchar2(60);

Line 3604: -- First get the id of standard pay table for later use

3600: BEGIN
3601: hr_utility.set_location('Entering ...'|| l_proc,5);
3602: g_gm_unadjd_basic_pay := NULL;
3603: gm_unadjusted_pay_flg := NULL;
3604: -- First get the id of standard pay table for later use
3605: FOR c_rec IN get_std_user_table_id LOOP
3606: l_std_user_table_id := c_rec.user_table_id;
3607: END LOOP;
3608:

Line 3783: IF l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) AND

3779: g_fwfa_pay_calc_flag := FALSE;
3780: RETURN FALSE;
3781: END IF;
3782: ELSE
3783: IF l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) AND
3784: l_gs_equivalent THEN
3785: g_fwfa_pay_calc_flag := TRUE;
3786: RETURN TRUE;
3787: ELSE

Line 4075: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4071: g_pay_table_upd_flag := FALSE;
4072: ELSE
4073: p_position_pay_table := p_special_rate_table;
4074: p_new_prd := '0';
4075: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4076: g_pay_table_upd_flag := FALSE;
4077: END IF;
4078: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4079: p_position_pay_table := p_special_rate_table;

Line 4081: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4077: END IF;
4078: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4079: p_position_pay_table := p_special_rate_table;
4080: p_new_prd := '0';
4081: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4082: g_pay_table_upd_flag := FALSE;
4083: ELSE
4084: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4085: p_new_prd := '0';

Line 4084: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4080: p_new_prd := '0';
4081: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4082: g_pay_table_upd_flag := FALSE;
4083: ELSE
4084: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4085: p_new_prd := '0';
4086: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4087: g_pay_table_upd_flag := TRUE;
4088: END IF;

Line 4086: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4082: g_pay_table_upd_flag := FALSE;
4083: ELSE
4084: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4085: p_new_prd := '0';
4086: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4087: g_pay_table_upd_flag := TRUE;
4088: END IF;
4089: ELSIF p_prd IN ('E','F') THEN
4090: IF p_pp_grd_exists AND p_pt_value IS NOT NULL THEN

Line 4103: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4099: p_new_prd := 'A';
4100: ELSIF p_prd = 'F' THEN
4101: p_new_prd := 'B';
4102: END IF;
4103: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4104: g_pay_table_upd_flag := FALSE;
4105: END IF;
4106: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4107: p_retained_pay_table := p_special_rate_table;

Line 4113: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4109: p_new_prd := 'A';
4110: ELSIF p_prd = 'F' THEN
4111: p_new_prd := 'B';
4112: END IF;
4113: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4114: g_pay_table_upd_flag := FALSE;
4115: ELSE
4116: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;
4117: IF p_prd = 'E' THEN

Line 4116: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;

4112: END IF;
4113: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4114: g_pay_table_upd_flag := FALSE;
4115: ELSE
4116: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;
4117: IF p_prd = 'E' THEN
4118: p_new_prd := 'A';
4119: ELSIF p_prd = 'F' THEN
4120: p_new_prd := 'B';

Line 4122: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4118: p_new_prd := 'A';
4119: ELSIF p_prd = 'F' THEN
4120: p_new_prd := 'B';
4121: END IF;
4122: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4123: g_pay_table_upd_flag := TRUE;
4124: END IF;
4125: ELSIF p_prd IN ('3','4','J','K','U','V','R') THEN
4126: IF NOT(p_pp_grd_exists) THEN

Line 4127: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4123: g_pay_table_upd_flag := TRUE;
4124: END IF;
4125: ELSIF p_prd IN ('3','4','J','K','U','V','R') THEN
4126: IF NOT(p_pp_grd_exists) THEN
4127: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4128: g_pay_table_upd_flag := TRUE;
4129: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4130: ELSE
4131: p_position_pay_table := p_special_rate_table;

Line 4129: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4125: ELSIF p_prd IN ('3','4','J','K','U','V','R') THEN
4126: IF NOT(p_pp_grd_exists) THEN
4127: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4128: g_pay_table_upd_flag := TRUE;
4129: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4130: ELSE
4131: p_position_pay_table := p_special_rate_table;
4132: g_pay_table_upd_flag := FALSE;
4133: p_calculation_pay_table := p_special_rate_table;

Line 4157: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4153: g_pay_table_upd_flag := FALSE;
4154: ELSE
4155: p_position_pay_table := p_special_rate_table;
4156: p_new_prd := p_prd;
4157: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4158: g_pay_table_upd_flag := FALSE;
4159: END IF;
4160: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4161: p_position_pay_table := p_special_rate_table;

Line 4163: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4159: END IF;
4160: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4161: p_position_pay_table := p_special_rate_table;
4162: p_new_prd := p_prd;
4163: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4164: g_pay_table_upd_flag := FALSE;
4165: ELSE
4166: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4167: p_new_prd := p_prd;

Line 4166: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4162: p_new_prd := p_prd;
4163: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4164: g_pay_table_upd_flag := FALSE;
4165: ELSE
4166: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4167: p_new_prd := p_prd;
4168: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4169: g_pay_table_upd_flag := TRUE;
4170: END IF;

Line 4168: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4164: g_pay_table_upd_flag := FALSE;
4165: ELSE
4166: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4167: p_new_prd := p_prd;
4168: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4169: g_pay_table_upd_flag := TRUE;
4170: END IF;
4171: END IF;
4172: END IF;

Line 4255: l_default_pay_table := ghr_pay_calc.l_standard_table_name;

4251: l_leo_flag := TRUE;
4252: l_default_pay_table := ghr_pay_calc.l_spl491_table_name;
4253: ELSE
4254: l_leo_flag := FALSE;
4255: l_default_pay_table := ghr_pay_calc.l_standard_table_name;
4256: END IF;
4257:
4258:
4259: --Bug #5919700 For 890 action and GM Pay plan GS should be considered

Line 4437: l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN

4433: -- Then new basic = current basic + (new special rate step10 value - old special rate step 10 value/2)
4434:
4435: IF l_old_basic_pay IS NOT NULL AND l_special_rate IS NOT NULL AND
4436:
4437: l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN
4438:
4439: l_increment := Round((l_special_rate - l_old_basic_pay)/2,0);
4440: hr_utility.set_location('INCREMENTED HALF VALUE'||l_increment,7788);
4441: l_new_basic_pay := p_pay_calc_data.current_basic_pay + l_increment;

Line 4560: IF l_term_ret_pay_prd and l_gr_pay_plan and l_calculation_pay_table = ghr_pay_calc.l_standard_table_name then

4556: END IF;
4557: END IF; --IF NVL(l_special_rate,0)
4558: -- Set the PRD if Pay Retention is terminated.
4559: -- 7046241
4560: IF l_term_ret_pay_prd and l_gr_pay_plan and l_calculation_pay_table = ghr_pay_calc.l_standard_table_name then
4561: ghr_history_fetch.fetch_positionei(
4562: p_position_id => p_pay_calc_data.position_id,
4563: p_information_type => 'GHR_US_POS_VALID_GRADE',
4564: p_date_effective => p_pay_calc_data.effective_date,

Line 4577: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4573: END IF;
4574: -- 7046241
4575: IF l_term_ret_pay_prd THEN
4576: IF p_pay_calc_data.pay_rate_determinant IN ('3','4','J','K','R') THEN
4577: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4578: l_new_prd := '0';
4579: ELSE
4580: l_new_prd := '6';
4581: END IF;

Line 4583: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4579: ELSE
4580: l_new_prd := '6';
4581: END IF;
4582: ELSIF p_pay_calc_data.pay_rate_determinant = 'U' THEN
4583: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4584: l_new_prd := 'B';
4585: ELSE
4586: l_new_prd := 'F';
4587: END IF;

Line 4589: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4585: ELSE
4586: l_new_prd := 'F';
4587: END IF;
4588: ELSIF p_pay_calc_data.pay_rate_determinant = 'V' THEN
4589: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4590: l_new_prd := 'A';
4591: ELSE
4592: l_new_prd := 'E';
4593: END IF;

Line 4632: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;

4628: END IF;
4629: -- Added this IF condition Bug#5114467
4630: IF l_pay_plan NOT IN ('GM','GR') THEN
4631: --Bug# 7518210 added GR
4632: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;
4633: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4634: g_pay_table_upd_flag := TRUE;
4635: l_new_prd := '0';
4636: l_new_basic_pay := ROUND(p_pay_calc_data.current_adj_basic_pay / (1 + l_adj_perc_factor),0);

Line 4633: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4629: -- Added this IF condition Bug#5114467
4630: IF l_pay_plan NOT IN ('GM','GR') THEN
4631: --Bug# 7518210 added GR
4632: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;
4633: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4634: g_pay_table_upd_flag := TRUE;
4635: l_new_prd := '0';
4636: l_new_basic_pay := ROUND(p_pay_calc_data.current_adj_basic_pay / (1 + l_adj_perc_factor),0);
4637: l_new_locality_adj := ROUND(l_new_basic_pay * l_adj_perc_factor);

Line 4782: IF l_user_table_name IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN

4778: l_new_adj_basic_pay := l_new_basic_pay + l_new_locality_adj;
4779: l_calculation_pay_table := get_user_table_name(l_user_table_id);
4780: ELSE --End Bug# 5608741
4781: -- Processing of NOACs other than WGI/QSI
4782: IF l_user_table_name IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN
4783: l_pay_calc_process := 'L';
4784: ELSE
4785: hr_utility.set_location('user tbale id: '||to_char(l_user_table_id),40);
4786: hr_utility.set_location('pay Plan: '||l_pay_plan,50);

Line 4917: IF l_calculation_pay_table <> ghr_pay_calc.l_standard_table_name THEN

4913: -- And Code for determining Calculation pay table For Regular Emp. in GM pay table and 894 action
4914: IF l_pay_plan = 'GM' AND p_pay_calc_data.noa_code= 894 THEN
4915: -- AC : Bug#5725928 - Added the condition so that the pay adjustment process should be
4916: -- doing the comparison of locality verses special rate only if the pay table is not 0000
4917: IF l_calculation_pay_table <> ghr_pay_calc.l_standard_table_name THEN
4918: IF l_new_locality_adj > l_new_special_rate THEN
4919: l_new_prd := '0';
4920: ELSE
4921: l_new_prd := '6';

Line 5125: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;

5121: AND p_grade_or_level between 03 and 10 THEN
5122: l_std_user_table_name := Ghr_pay_calc.l_spl491_table_name;
5123:
5124: ELSE
5125: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;
5126:
5127: END IF;
5128: FOR c_rec IN get_user_table_id(l_std_user_table_name) LOOP
5129: l_std_user_table_id := c_rec.user_table_id;

Line 5190: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;

5186: AND p_grade_or_level between 03 and 10 THEN
5187: l_std_user_table_name := Ghr_pay_calc.l_spl491_table_name;
5188:
5189: ELSE
5190: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;
5191:
5192: END IF;
5193: FOR c_rec IN get_user_table_id(l_std_user_table_name) LOOP
5194: l_std_user_table_id := c_rec.user_table_id;