APPS.PAY_MX_PTU_CALC dependencies on HRUSERDT

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

639:
640: ld_end_date := ADD_MONTHS(ld_start_date, 12) - 1;
641:
642: BEGIN
643: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
644: 'PTU Factors',
645: 'Calculation Method',
646: lv_legal_ER_name,
647: ld_end_date),

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

651: g_ptu_calc_method := 'DAILY_WAGE';
652: END;
653:
654: BEGIN
655: lv_incl_temp_EEs := NVL(hruserdt.get_table_value(ln_business_group_id,
656: 'PTU Factors',
657: 'Include Temporary Workers (Y/N)?',
658: lv_legal_ER_name,
659: ld_end_date), 'Y');

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

662: lv_incl_temp_EEs := 'Y';
663: END;
664:
665: BEGIN
666: ln_min_days_worked := NVL(TO_NUMBER(hruserdt.get_table_value(
667: ln_business_group_id,
668: 'PTU Factors',
669: 'Minimum Days Worked',
670: lv_legal_ER_name,

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

714: ld_end_date);
715: END IF;
716:
717: BEGIN
718: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,
719: 'PTU Factors',
720: 'Total Worked Days (Factor F)',
721: lv_legal_ER_name,
722: ld_end_date);

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

725: ln_factor_F := NULL;
726: END;
727:
728: BEGIN
729: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,
730: 'PTU Factors',
731: 'Total Capped Average Salary (Factor G)',
732: lv_legal_ER_name,
733: ld_end_date);

Line 898: hruserdt.get_table_value(

894:
895: BEGIN
896:
897: ln_factor_D := 1.2 *
898: hruserdt.get_table_value(
899: ln_business_group_id,
900: 'PTU Factors',
901: 'Highest Average Daily Salary',
902: lv_legal_ER_name,

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

1318:
1319: ln_step := 2;
1320:
1321: BEGIN
1322: ln_tot_share_amt := hruserdt.get_table_value(ln_business_group_id,
1323: 'PTU Factors',
1324: 'Total Amount to Share',
1325: lv_legal_ER_name,
1326: ld_end_date);

Line 1337: hruserdt.get_table_value(ln_business_group_id,

1333: ln_factor_A := ln_tot_share_amt / 2;
1334:
1335: BEGIN
1336: ln_factor_D := 1.2 *
1337: hruserdt.get_table_value(ln_business_group_id,
1338: 'PTU Factors',
1339: 'Highest Average Daily Salary',
1340: lv_legal_ER_name,
1341: ld_end_date);

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

1345: hr_utility.raise_error;
1346: END;
1347:
1348: BEGIN
1349: ln_factor_F := hruserdt.get_table_value(ln_business_group_id,
1350: 'PTU Factors',
1351: 'Total Worked Days (Factor F)',
1352: lv_legal_ER_name,
1353: ld_end_date);

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

1356: ln_factor_F := NULL;
1357: END;
1358:
1359: BEGIN
1360: ln_factor_G := hruserdt.get_table_value(ln_business_group_id,
1361: 'PTU Factors',
1362: 'Total Capped Average Salary (Factor G)',
1363: lv_legal_ER_name,
1364: ld_end_date);

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

1416:
1417: END IF;
1418:
1419: BEGIN
1420: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
1421: 'PTU Factors',
1422: 'Calculation Method',
1423: lv_legal_ER_name,
1424: ld_end_date),

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

1570: hr_utility.trace('ld_end_date: '||ld_end_date);
1571: hr_utility.trace('lv_legal_ER_name: '||lv_legal_ER_name);
1572:
1573: BEGIN
1574: g_ptu_calc_method := NVL(hruserdt.get_table_value(ln_business_group_id,
1575: 'PTU Factors',
1576: 'Calculation Method',
1577: lv_legal_ER_name,
1578: ld_end_date),