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 1247: 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)

1243: --Bug 4740036 Start
1244: --8320557 From 12 -Apr-2009 locality pay will be 0 for SL ST IP pay plan
1245: ELSIF l_pay_plan IN ('SL','ST','IP') AND p_pay_calc_data.effective_date >= to_date('2009/04/12','YYYY/MM/DD') THEN
1246: l_locality_adj := 0;
1247: 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)
1248: AND l_pay_plan in ('GG','GS')
1249: AND p_pay_calc_data.pay_rate_determinant IN ('6','E','F')
1250: AND ghr_pay_calc.LEO_position (l_dummy
1251: ,p_pay_calc_data.position_id

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

1252: ,l_dummy
1253: ,l_dummy
1254: ,p_pay_calc_data.effective_date) THEN
1255: hr_utility.set_location('AB p_pay_calc_data.pay_rate_determinant ' || p_pay_calc_data.pay_rate_determinant,99);
1256: FOR c_rec IN c_user_table_id(ghr_pay_calc.l_standard_table_name) LOOP
1257: l_std_user_table_id := c_rec.user_table_id;
1258: END LOOP;
1259: hr_utility.set_location('AB l_std_user_table_id ' || l_std_user_table_id,99);
1260: IF p_pay_calc_data.pay_rate_determinant = '6' THEN

Line 1392: -- the standard table 'GS'

1388: IF l_pay_plan NOT IN ('GM','GH') THEN
1389: --
1390: -- Sundar 3294560 If Pay plan is 'GG' take from 'GG' else take from GS.
1391: -- Pay Plan should be either GG or GS, if not in 'GM', 'GH'. If not, then assign
1392: -- the standard table 'GS'
1393: IF l_pay_plan NOT IN ('GG','GS') THEN
1394: l_pay_plan := 'GS';
1395: END IF; -- IF l_pay_plan NOT IN ('GG','GS')
1396:

Line 1397: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1393: IF l_pay_plan NOT IN ('GG','GS') THEN
1394: l_pay_plan := 'GS';
1395: END IF; -- IF l_pay_plan NOT IN ('GG','GS')
1396:
1397: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1398: ,p_pay_calc_data.grade_or_level
1399: ,NVL(p_pay_calc_out_data.out_step_or_rate,p_pay_calc_data.step_or_rate)
1400: ,p_pay_calc_data.effective_date);
1401: -- End Bug 3294560

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

1408: --
1409: IF l_pay_plan NOT IN ('GM','GH') THEN
1410: --
1411: -- Sundar 3294560 If Pay plan is 'GG' take from 'GG' else take from GS.
1412: -- Pay Plan should be either GG or GS, if not in 'GM', 'GH'. If not, then -- the standard table 'GS'
1413: IF l_pay_plan NOT IN ('GG','GS','GL') THEN
1414: l_pay_plan := 'GS';
1415: END IF; -- IF l_pay_plan NOT IN ('GG','GS','GL')
1416:

Line 1475: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1471:
1472: -- Bug 3294560 Hard coding of 'GS' replaced with l_pay_plan
1473: IF p_retained_grade.temp_step IS NOT NULL THEN
1474:
1475: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1476: ,p_pay_calc_data.grade_or_level
1477: ,l_new_step_or_rate
1478: ,p_pay_calc_data.effective_date);
1479: ELSE

Line 1480: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1476: ,p_pay_calc_data.grade_or_level
1477: ,l_new_step_or_rate
1478: ,p_pay_calc_data.effective_date);
1479: ELSE
1480: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1481: ,p_retained_grade.grade_or_level
1482: ,l_new_step_or_rate
1483: ,p_pay_calc_data.effective_date);
1484: END IF;

Line 1488: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1484: END IF;
1485: ELSE
1486: --- Bug 1953725 End
1487: if p_retained_grade.temp_step is not null then
1488: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1489: ,p_pay_calc_data.grade_or_level
1490: ,p_retained_grade.temp_step
1491: ,p_pay_calc_data.effective_date);
1492: else

Line 1493: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan

1489: ,p_pay_calc_data.grade_or_level
1490: ,p_retained_grade.temp_step
1491: ,p_pay_calc_data.effective_date);
1492: else
1493: l_default_basic_pay := get_standard_pay_table_value (l_pay_plan
1494: ,p_retained_grade.grade_or_level
1495: ,p_retained_grade.step_or_rate
1496: ,p_pay_calc_data.effective_date);
1497: end if;

Line 2602: get_user_table_name(l_pay_calc_data.user_table_id) in (ghr_pay_calc.l_spl491_table_name,ghr_pay_calc.l_standard_table_name) THEN

2598:
2599: --BUG # 13341602 Added to set back the PRD to 0 If previously it was set to 6 by
2600: -- Special Rate and now it is changed to 0000 table
2601: IF l_pay_calc_data.pay_rate_determinant = '6' AND
2602: get_user_table_name(l_pay_calc_data.user_table_id) in (ghr_pay_calc.l_spl491_table_name,ghr_pay_calc.l_standard_table_name) THEN
2603: l_pay_calc_out_data.out_pay_rate_determinant := '0';
2604: END IF;
2605:
2606: -- FWFA Changes

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

3004: l_pay_calc_out_data.open_localityadj_field := TRUE;
3005: end if;*/
3006: --Begin Bug# 7557159
3007: IF l_pay_plan='GS' AND l_pay_rate_determinant='D' THEN
3008: l_prd_d_pay_amount := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => l_pay_plan
3009: ,p_grade_or_level => l_grade_or_level
3010: ,p_step_or_rate => '10'
3011: ,p_effective_date => p_effective_date);
3012:

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

3236: ,p_PT_eff_start_date => l_PT_o_eff_start_date
3237: ,p_PT_eff_end_date => l_PT_o_eff_end_date);
3238:
3239: hr_utility.set_location('l_PT_o_value ...'|| to_char(l_PT_o_value),5);
3240: l_SPT_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan
3241: ,p_grade_or_level => p_grade_or_level
3242: ,p_step_or_rate => p_step_or_rate
3243: ,p_effective_date => p_effective_date);
3244:

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

3242: ,p_step_or_rate => p_step_or_rate
3243: ,p_effective_date => p_effective_date);
3244:
3245: hr_utility.set_location('l_SPT_value ...'|| to_char(l_SPT_value),5);
3246: l_SPT_o_value := ghr_pay_calc.get_standard_pay_table_value (p_pay_plan => p_pay_plan
3247: ,p_grade_or_level => p_grade_or_level
3248: ,p_step_or_rate => p_step_or_rate
3249: ,p_effective_date => (l_PT_eff_start_date -1) );
3250:

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

3321:
3322: CURSOR get_std_user_table_id IS
3323: SELECT utb.user_table_id
3324: FROM pay_user_tables utb
3325: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3326:
3327: BEGIN
3328: hr_utility.set_location('Entering ...'|| l_proc,5);
3329: -- First get the id of standard pay table for later use

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

3325: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3326:
3327: BEGIN
3328: hr_utility.set_location('Entering ...'|| l_proc,5);
3329: -- First get the id of standard pay table for later use
3330: FOR c_rec IN get_std_user_table_id LOOP
3331: l_std_user_table_id := c_rec.user_table_id;
3332: END LOOP;
3333:

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

3418: IF l_new_std_relative_rate > new_adj_basic_pay THEN
3419: new_adj_basic_pay := l_new_std_relative_rate;
3420: new_locality_adj := new_adj_basic_pay - l_new_basic_pay;
3421: ELSIF (l_new_basic_pay > new_adj_basic_pay) AND
3422: (l_user_table_name <> ghr_pay_calc.l_standard_table_name) THEN
3423: new_adj_basic_pay := l_new_basic_pay;
3424: new_locality_adj := 0;
3425: END IF;
3426:

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

3615:
3616: CURSOR get_std_user_table_id IS
3617: SELECT utb.user_table_id
3618: FROM pay_user_tables utb
3619: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3620:
3621: ----
3622: l_assignment_id per_assignments_f.assignment_id%type;
3623: l_value varchar2(60);

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

3637: BEGIN
3638: hr_utility.set_location('Entering ...'|| l_proc,5);
3639: g_gm_unadjd_basic_pay := NULL;
3640: gm_unadjusted_pay_flg := NULL;
3641: -- First get the id of standard pay table for later use
3642: FOR c_rec IN get_std_user_table_id LOOP
3643: l_std_user_table_id := c_rec.user_table_id;
3644: END LOOP;
3645:

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

3792:
3793: CURSOR get_std_user_table_id IS
3794: SELECT utb.user_table_id
3795: FROM pay_user_tables utb
3796: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3797:
3798: ----
3799: l_assignment_id per_assignments_f.assignment_id%type;
3800: l_value varchar2(60);

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

3814: BEGIN
3815: hr_utility.set_location('Entering ...'|| l_proc,5);
3816: g_gm_unadjd_basic_pay := NULL;
3817: gm_unadjusted_pay_flg := NULL;
3818: -- First get the id of standard pay table for later use
3819: FOR c_rec IN get_std_user_table_id LOOP
3820: l_std_user_table_id := c_rec.user_table_id;
3821: END LOOP;
3822:

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

3994: g_fwfa_pay_calc_flag := FALSE;
3995: RETURN FALSE;
3996: END IF;
3997: ELSE
3998: IF l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) AND
3999: l_gs_equivalent THEN
4000: g_fwfa_pay_calc_flag := TRUE;
4001: RETURN TRUE;
4002: ELSE

Line 4338: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4334: g_pay_table_upd_flag := FALSE;
4335: ELSE
4336: p_position_pay_table := p_special_rate_table;
4337: p_new_prd := '0';
4338: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4339: g_pay_table_upd_flag := FALSE;
4340: END IF;
4341: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4342: p_position_pay_table := p_special_rate_table;

Line 4344: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4340: END IF;
4341: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4342: p_position_pay_table := p_special_rate_table;
4343: p_new_prd := '0';
4344: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4345: g_pay_table_upd_flag := FALSE;
4346: ELSE
4347: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4348: p_new_prd := '0';

Line 4347: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4343: p_new_prd := '0';
4344: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4345: g_pay_table_upd_flag := FALSE;
4346: ELSE
4347: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4348: p_new_prd := '0';
4349: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4350: g_pay_table_upd_flag := TRUE;
4351: END IF;

Line 4349: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4345: g_pay_table_upd_flag := FALSE;
4346: ELSE
4347: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4348: p_new_prd := '0';
4349: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4350: g_pay_table_upd_flag := TRUE;
4351: END IF;
4352: ELSIF p_prd IN ('E','F') THEN
4353: IF p_pp_grd_exists AND p_pt_value IS NOT NULL THEN

Line 4366: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4362: p_new_prd := 'A';
4363: ELSIF p_prd = 'F' THEN
4364: p_new_prd := 'B';
4365: END IF;
4366: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4367: g_pay_table_upd_flag := FALSE;
4368: END IF;
4369: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4370: p_retained_pay_table := p_special_rate_table;

Line 4376: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4372: p_new_prd := 'A';
4373: ELSIF p_prd = 'F' THEN
4374: p_new_prd := 'B';
4375: END IF;
4376: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4377: g_pay_table_upd_flag := FALSE;
4378: ELSE
4379: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;
4380: IF p_prd = 'E' THEN

Line 4379: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;

4375: END IF;
4376: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4377: g_pay_table_upd_flag := FALSE;
4378: ELSE
4379: p_retained_pay_table := ghr_pay_calc.l_standard_table_name;
4380: IF p_prd = 'E' THEN
4381: p_new_prd := 'A';
4382: ELSIF p_prd = 'F' THEN
4383: p_new_prd := 'B';

Line 4385: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4381: p_new_prd := 'A';
4382: ELSIF p_prd = 'F' THEN
4383: p_new_prd := 'B';
4384: END IF;
4385: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4386: g_pay_table_upd_flag := TRUE;
4387: END IF;
4388: ELSIF p_prd IN ('3','4','J','K','U','V','R','Y') THEN -- Bug# 9255822 added PRD Y
4389: IF NOT(p_pp_grd_exists) THEN

Line 4390: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4386: g_pay_table_upd_flag := TRUE;
4387: END IF;
4388: ELSIF p_prd IN ('3','4','J','K','U','V','R','Y') THEN -- Bug# 9255822 added PRD Y
4389: IF NOT(p_pp_grd_exists) THEN
4390: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4391: g_pay_table_upd_flag := TRUE;
4392: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4393: ELSE
4394: p_position_pay_table := p_special_rate_table;

Line 4392: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4388: ELSIF p_prd IN ('3','4','J','K','U','V','R','Y') THEN -- Bug# 9255822 added PRD Y
4389: IF NOT(p_pp_grd_exists) THEN
4390: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4391: g_pay_table_upd_flag := TRUE;
4392: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4393: ELSE
4394: p_position_pay_table := p_special_rate_table;
4395: g_pay_table_upd_flag := FALSE;
4396: p_calculation_pay_table := p_special_rate_table;

Line 4420: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4416: g_pay_table_upd_flag := FALSE;
4417: ELSE
4418: p_position_pay_table := p_special_rate_table;
4419: p_new_prd := p_prd;
4420: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4421: g_pay_table_upd_flag := FALSE;
4422: END IF;
4423: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4424: p_position_pay_table := p_special_rate_table;

Line 4426: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4422: END IF;
4423: ELSIF p_pp_grd_exists AND p_pt_value IS NULL THEN
4424: p_position_pay_table := p_special_rate_table;
4425: p_new_prd := p_prd;
4426: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4427: g_pay_table_upd_flag := FALSE;
4428: ELSE
4429: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4430: p_new_prd := p_prd;

Line 4429: p_position_pay_table := ghr_pay_calc.l_standard_table_name;

4425: p_new_prd := p_prd;
4426: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4427: g_pay_table_upd_flag := FALSE;
4428: ELSE
4429: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4430: p_new_prd := p_prd;
4431: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4432: g_pay_table_upd_flag := TRUE;
4433: END IF;

Line 4431: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4427: g_pay_table_upd_flag := FALSE;
4428: ELSE
4429: p_position_pay_table := ghr_pay_calc.l_standard_table_name;
4430: p_new_prd := p_prd;
4431: p_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4432: g_pay_table_upd_flag := TRUE;
4433: END IF;
4434: END IF;
4435: END IF;

Line 4518: l_default_pay_table := ghr_pay_calc.l_standard_table_name;

4514: l_leo_flag := TRUE;
4515: l_default_pay_table := ghr_pay_calc.l_spl491_table_name;
4516: ELSE
4517: l_leo_flag := FALSE;
4518: l_default_pay_table := ghr_pay_calc.l_standard_table_name;
4519: END IF;
4520:
4521:
4522: --Bug #5919700 For 890 action and GM Pay plan GS should be considered

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

4803: l_old_special_rate := l_old_adj_basic_pay;
4804: END IF;
4805:
4806: IF l_old_special_rate IS NOT NULL AND l_special_rate IS NOT NULL AND
4807: l_user_table_name NOT IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN
4808:
4809: l_increment := Round((l_special_rate - l_old_special_rate)/2,0);
4810: hr_utility.set_location('INCREMENTED HALF VALUE'||l_increment,7788);
4811: l_new_basic_pay := p_pay_calc_data.current_basic_pay + l_increment;

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

4905: END IF; --IF NVL(l_special_rate,0)
4906:
4907: -- Set the PRD if Pay Retention is terminated.
4908: -- 7046241
4909: IF l_term_ret_pay_prd and l_gr_pay_plan and l_calculation_pay_table = ghr_pay_calc.l_standard_table_name then
4910: ghr_history_fetch.fetch_positionei(
4911: p_position_id => p_pay_calc_data.position_id,
4912: p_information_type => 'GHR_US_POS_VALID_GRADE',
4913: p_date_effective => p_pay_calc_data.effective_date,

Line 4926: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4922: END IF;
4923: -- 7046241
4924: IF l_term_ret_pay_prd THEN
4925: IF p_pay_calc_data.pay_rate_determinant IN ('3','4','J','K','R','Y') THEN -- Bug# 9255822 added PRD Y
4926: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4927: l_new_prd := '0';
4928: ELSE
4929: l_new_prd := '6';
4930: END IF;

Line 4932: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4928: ELSE
4929: l_new_prd := '6';
4930: END IF;
4931: ELSIF p_pay_calc_data.pay_rate_determinant = 'U' THEN
4932: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4933: l_new_prd := 'B';
4934: ELSE
4935: l_new_prd := 'F';
4936: END IF;

Line 4938: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN

4934: ELSE
4935: l_new_prd := 'F';
4936: END IF;
4937: ELSIF p_pay_calc_data.pay_rate_determinant = 'V' THEN
4938: IF l_calculation_pay_table = ghr_pay_calc.l_standard_table_name THEN
4939: l_new_prd := 'A';
4940: ELSE
4941: l_new_prd := 'E';
4942: END IF;

Line 4981: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;

4977: END IF;
4978: -- Added this IF condition Bug#5114467
4979: IF l_pay_plan NOT IN ('GM','GR') THEN
4980: --Bug# 7518210 added GR
4981: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;
4982: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4983: g_pay_table_upd_flag := TRUE;
4984: l_new_prd := '0';
4985: l_new_basic_pay := ROUND(p_pay_calc_data.current_adj_basic_pay / (1 + l_adj_perc_factor),0);

Line 4982: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;

4978: -- Added this IF condition Bug#5114467
4979: IF l_pay_plan NOT IN ('GM','GR') THEN
4980: --Bug# 7518210 added GR
4981: l_new_Position_Pay_Table := ghr_pay_calc.l_standard_table_name;
4982: l_calculation_pay_table := ghr_pay_calc.l_standard_table_name;
4983: g_pay_table_upd_flag := TRUE;
4984: l_new_prd := '0';
4985: l_new_basic_pay := ROUND(p_pay_calc_data.current_adj_basic_pay / (1 + l_adj_perc_factor),0);
4986: l_new_locality_adj := ROUND(l_new_basic_pay * l_adj_perc_factor);

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

5127: l_new_adj_basic_pay := l_new_basic_pay + l_new_locality_adj;
5128: l_calculation_pay_table := get_user_table_name(l_user_table_id);
5129: ELSE --End Bug# 5608741
5130: -- Processing of NOACs other than WGI/QSI
5131: IF l_user_table_name IN (ghr_pay_calc.l_standard_table_name,ghr_pay_calc.l_spl491_table_name) THEN
5132: l_pay_calc_process := 'L';
5133: ELSE
5134: hr_utility.set_location('user tbale id: '||to_char(l_user_table_id),40);
5135: hr_utility.set_location('pay Plan: '||l_pay_plan,50);

Line 5266: IF l_calculation_pay_table <> ghr_pay_calc.l_standard_table_name THEN

5262: -- And Code for determining Calculation pay table For Regular Emp. in GM pay table and 894 action
5263: IF l_pay_plan = 'GM' AND p_pay_calc_data.noa_code= 894 THEN
5264: -- AC : Bug#5725928 - Added the condition so that the pay adjustment process should be
5265: -- doing the comparison of locality verses special rate only if the pay table is not 0000
5266: IF l_calculation_pay_table <> ghr_pay_calc.l_standard_table_name THEN
5267: IF l_new_locality_adj > l_new_special_rate THEN
5268: l_new_prd := '0';
5269: ELSE
5270: l_new_prd := '6';

Line 5469: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;

5465: AND p_grade_or_level between 03 and 10 THEN
5466: l_std_user_table_name := Ghr_pay_calc.l_spl491_table_name;
5467:
5468: ELSE
5469: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;
5470:
5471: END IF;
5472: FOR c_rec IN get_user_table_id(l_std_user_table_name) LOOP
5473: l_std_user_table_id := c_rec.user_table_id;

Line 5529: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;

5525: AND p_grade_or_level between 03 and 10 THEN
5526: l_std_user_table_name := Ghr_pay_calc.l_spl491_table_name;
5527:
5528: ELSE
5529: l_std_user_table_name := Ghr_pay_calc.l_standard_table_name;
5530:
5531: END IF;
5532: FOR c_rec IN get_user_table_id(l_std_user_table_name) LOOP
5533: l_std_user_table_id := c_rec.user_table_id;