DBA Data[Home] [Help]

APPS.HR_GENERATE_PRETAX dependencies on PAY_ELEMENT_TYPES_F

Line 99: while updating PAY_ELEMENT_TYPES_F for

95: 27-oct-1999 dscully Added check for legislation_code while
96: looking up skip rules
97: 12-Jul-2000 kthirmiy 110.14 Added ELEMENT_INFORMATION_CATEGORY=
98: 'US_EMPLOYER LIABILITIES'
99: while updating PAY_ELEMENT_TYPES_F for
100: pretax ER element to show the desc flex
101: field in the element description screen
102: for pretax ER element
103: *******************************************************************************

Line 1323: UPDATE pay_element_types_f

1319:
1320: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1321:
1322: -- For CALCULATOR ele, set mix flag and ben class if approp...
1323: UPDATE pay_element_types_f
1324: SET element_information_category = g_ele_info_cat,
1325: element_information1 = p_ele_cat,
1326: element_information2 = p_partial_dedn,
1327: element_information3 = p_proc_runtype,

Line 1334: UPDATE pay_element_types_f

1330: WHERE element_type_id = dedn_ele_ids(1)
1331: AND business_group_id + 0 = p_bg_id;
1332:
1333: -- For WITHHOLDING element, do not set mix flag or ben class...
1334: UPDATE pay_element_types_f
1335: SET element_information_category = g_ele_info_cat,
1336: element_information1 = p_ele_cat,
1337: element_information2 = p_partial_dedn,
1338: element_information3 = p_proc_runtype,

Line 1345: UPDATE pay_element_types_f

1341: AND business_group_id + 0 = p_bg_id;
1342:
1343: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1344:
1345: UPDATE pay_element_types_f
1346: SET element_information_category = g_ele_info_cat,
1347: element_information1 = p_ele_cat,
1348: element_information2 = p_partial_dedn,
1349: element_information3 = p_proc_runtype

Line 1355: UPDATE pay_element_types_f

1351: AND business_group_id + 0 = p_bg_id;
1352:
1353: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',05);
1354:
1355: UPDATE pay_element_types_f
1356: SET element_information_category = g_ele_info_cat,
1357: element_information1 = p_ele_cat,
1358: element_information2 = p_partial_dedn,
1359: element_information3 = p_proc_runtype

Line 1391: UPDATE pay_element_types_f

1387:
1388: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1389:
1390: -- For CALCULATOR, set mix flag and ben class...
1391: UPDATE pay_element_types_f
1392: SET element_information_category = g_ele_info_cat,
1393: element_information1 = p_ele_cat,
1394: element_information2 = p_partial_dedn,
1395: element_information3 = p_proc_runtype,

Line 1404: UPDATE pay_element_types_f

1400: WHERE element_type_id = dedn_ele_ids(1)
1401: AND business_group_id + 0 = p_bg_id;
1402:
1403: -- For WITHHOLDING element, do not set mix flag or ben class...
1404: UPDATE pay_element_types_f
1405: SET element_information_category = g_ele_info_cat,
1406: element_information1 = p_ele_cat,
1407: element_information2 = p_partial_dedn,
1408: element_information3 = p_proc_runtype,

Line 1418: UPDATE pay_element_types_f

1414:
1415: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1416:
1417:
1418: UPDATE pay_element_types_f
1419: SET element_information_category = g_ele_info_cat,
1420: element_information1 = p_ele_cat,
1421: element_information2 = p_partial_dedn,
1422: element_information3 = p_proc_runtype,

Line 1431: UPDATE pay_element_types_f

1427:
1428: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',57);
1429:
1430:
1431: UPDATE pay_element_types_f
1432: SET element_information_category = g_ele_info_cat,
1433: element_information1 = p_ele_cat,
1434: element_information2 = p_partial_dedn,
1435: element_information3 = p_proc_runtype,

Line 1448: UPDATE pay_element_types_f

1444: -- Check for Benefits Table amount rule...
1445: ELSIF UPPER(p_amount_rule) = 'BT' THEN
1446:
1447: -- Set mix flag and ben class on CALCULATOR element...
1448: UPDATE pay_element_types_f
1449: SET element_information_category = g_ele_info_cat,
1450: element_information1 = p_ele_cat,
1451: element_information2 = p_partial_dedn,
1452: element_information3 = p_proc_runtype,

Line 1459: UPDATE pay_element_types_f

1455: WHERE element_type_id = dedn_ele_ids(1)
1456: AND business_group_id + 0 = p_bg_id;
1457:
1458: -- For WITHHOLDING element, do not set mix flag or ben class...
1459: UPDATE pay_element_types_f
1460: SET element_information_category = g_ele_info_cat,
1461: element_information1 = p_ele_cat,
1462: element_information2 = p_partial_dedn,
1463: element_information3 = p_proc_runtype,

Line 1472: UPDATE pay_element_types_f

1468:
1469: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);
1470:
1471:
1472: UPDATE pay_element_types_f
1473: SET element_information_category = g_ele_info_cat,
1474: element_information1 = p_ele_cat,
1475: element_information2 = p_partial_dedn,
1476: element_information3 = p_proc_runtype

Line 1483: UPDATE pay_element_types_f

1479:
1480:
1481: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',83);
1482:
1483: UPDATE pay_element_types_f
1484: SET element_information_category = g_ele_info_cat,
1485: element_information1 = p_ele_cat,
1486: element_information2 = p_partial_dedn,
1487: element_information3 = p_proc_runtype

Line 1503: UPDATE pay_element_types_f

1499:
1500: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1501:
1502: -- Set mix flag and ben class on CALCULATOR element...
1503: UPDATE pay_element_types_f
1504: SET element_information_category = g_ele_info_cat,
1505: element_information1 = p_ele_cat,
1506: element_information2 = p_partial_dedn,
1507: element_information3 = p_proc_runtype,

Line 1514: UPDATE pay_element_types_f

1510: WHERE element_type_id = dedn_ele_ids(1)
1511: AND business_group_id + 0 = p_bg_id;
1512:
1513: -- Do not set mix flag or ben class on WITHHOLDING element...
1514: UPDATE pay_element_types_f
1515: SET element_information_category = g_ele_info_cat,
1516: element_information1 = p_ele_cat,
1517: element_information2 = p_partial_dedn,
1518: element_information3 = p_proc_runtype,

Line 1527: UPDATE pay_element_types_f

1523:
1524: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1525:
1526:
1527: UPDATE pay_element_types_f
1528: SET element_information_category = g_ele_info_cat,
1529: element_information1 = p_ele_cat,
1530: element_information2 = p_partial_dedn,
1531: element_information3 = p_proc_runtype

Line 1538: UPDATE pay_element_types_f

1534:
1535: hr_utility.set_location('hr_generate_pretax.ins_dedn_formula_processing',81);
1536:
1537:
1538: UPDATE pay_element_types_f
1539: SET element_information_category = g_ele_info_cat,
1540: element_information1 = p_ele_cat,
1541: element_information2 = p_partial_dedn,
1542: element_information3 = p_proc_runtype

Line 4212: update pay_element_types_f

4208: p_bg_name => v_bg_name);
4209:
4210: -- Associate primary balance...need to look at emp liability ddf first!!!
4211: -- added element_information_Category 12-JUL-00
4212: update pay_element_types_f
4213: set ELEMENT_INFORMATION_CATEGORY='US_EMPLOYER LIABILITIES' ,
4214: element_information10 = v_er_charge_baltype_id
4215: where element_type_id = dedn_ele_ids(5)
4216: and g_eff_start_date between effective_start_date and effective_end_date;

Line 4503: UPDATE pay_element_types_f

4499: dedn_assoc_bal_ids(7) := Pretax-Able Balance;
4500: dedn_assoc_bal_ids(8) := Eligible Comp Balance;
4501: */
4502:
4503: UPDATE pay_element_types_f
4504: SET element_information10 = dedn_assoc_bal_ids(1), -- primary bal
4505: element_information11 = dedn_assoc_bal_ids(5), -- accrued bal
4506: element_information12 = dedn_assoc_bal_ids(6), -- arrears bal
4507: element_information13 = dedn_assoc_bal_ids(4), -- not taken bal