APPS.PAY_MX_PTU_CALC dependencies on HRUSERDT

Line 633: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,

629:
630: ld_end_date := ADD_MONTHS(ld_start_date, 12) - 1;
631:
632: BEGIN
633: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
634: 'PTU Factors',
635: 'Calculation Method',
636: lv_legal_ER_name,
637: ld_end_date),

Line 645: lv_incl_temp_EEs := NVL(hruserdt.get_table_value(ln_business_group_id,

641: g_ptu_calc_method := 'DAILY_WAGE';
642: END;
643:
644: BEGIN
645: lv_incl_temp_EEs := NVL(hruserdt.get_table_value(ln_business_group_id,
646: 'PTU Factors',
647: 'Include Temporary Workers (Y/N)?',
648: lv_legal_ER_name,
649: ld_end_date), 'Y');

Line 656: ln_min_days_worked := NVL(TO_NUMBER(hruserdt.get_table_value(

652: lv_incl_temp_EEs := 'Y';
653: END;
654:
655: BEGIN
656: ln_min_days_worked := NVL(TO_NUMBER(hruserdt.get_table_value(
657: ln_business_group_id,
658: 'PTU Factors',
659: 'Minimum Days Worked',
660: lv_legal_ER_name,

Line 708: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,

704: ld_end_date);
705: END IF;
706:
707: BEGIN
708: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,
709: 'PTU Factors',
710: 'Total Worked Days (Factor F)',
711: lv_legal_ER_name,
712: ld_end_date);

Line 719: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,

715: ln_factor_F := NULL;
716: END;
717:
718: BEGIN
719: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,
720: 'PTU Factors',
721: 'Total Capped Average Salary (Factor G)',
722: lv_legal_ER_name,
723: ld_end_date);

Line 864: hruserdt.get_table_value(

860:
861: BEGIN
862:
863: ln_factor_D := 1.2 *
864: hruserdt.get_table_value(
865: ln_business_group_id,
866: 'PTU Factors',
867: 'Highest Average Daily Salary',
868: lv_legal_ER_name,

Line 1285: ln_tot_share_amt := hruserdt.get_table_value(ln_business_group_id,

1281:
1282: ln_step := 2;
1283:
1284: BEGIN
1285: ln_tot_share_amt := hruserdt.get_table_value(ln_business_group_id,
1286: 'PTU Factors',
1287: 'Total Amount to Share',
1288: lv_legal_ER_name,
1289: ld_end_date);

Line 1300: hruserdt.get_table_value(ln_business_group_id,

1296: ln_factor_A := ln_tot_share_amt / 2;
1297:
1298: BEGIN
1299: ln_factor_D := 1.2 *
1300: hruserdt.get_table_value(ln_business_group_id,
1301: 'PTU Factors',
1302: 'Highest Average Daily Salary',
1303: lv_legal_ER_name,
1304: ld_end_date);

Line 1312: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,

1308: hr_utility.raise_error;
1309: END;
1310:
1311: BEGIN
1312: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,
1313: 'PTU Factors',
1314: 'Total Worked Days (Factor F)',
1315: lv_legal_ER_name,
1316: ld_end_date);

Line 1323: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,

1319: ln_factor_F := NULL;
1320: END;
1321:
1322: BEGIN
1323: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,
1324: 'PTU Factors',
1325: 'Total Capped Average Salary (Factor G)',
1326: lv_legal_ER_name,
1327: ld_end_date);

Line 1383: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,

1379:
1380: END IF;
1381:
1382: BEGIN
1383: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
1384: 'PTU Factors',
1385: 'Calculation Method',
1386: lv_legal_ER_name,
1387: ld_end_date),

Line 1535: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,

1531: hr_utility.trace('ld_end_date: '||ld_end_date);
1532: hr_utility.trace('lv_legal_ER_name: '||lv_legal_ER_name);
1533:
1534: BEGIN
1535: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
1536: 'PTU Factors',
1537: 'Calculation Method',
1538: lv_legal_ER_name,
1539: ld_end_date),