APPS.HR_ELEMENTS dependencies on HR_APPLICATION_OWNERSHIPS

Line 1161: delete from hr_application_ownerships ao

1157: if p_delete_mode = 'ZAP' then
1158: --
1159: if p_startup_mode <> 'USER' then
1160: --
1161: delete from hr_application_ownerships ao
1162: where key_name = 'FORMULA_RESULT_RULE_ID'
1163: and exists
1164: (select 1
1165: from pay_formula_result_rules_f frr

Line 1257: delete from hr_application_ownerships ao

1253: if p_delete_mode = 'ZAP' then
1254: --
1255: if p_startup_mode <> 'USER' then
1256: --
1257: delete from hr_application_ownerships ao
1258: where ao.key_name = 'STATUS_PROCESSING_RULE_ID'
1259: and exists
1260: (select 1
1261: from pay_status_processing_rules_f spr

Line 1330: delete from hr_application_ownerships ao

1326: if p_delete_mode = 'ZAP' then
1327: --
1328: if p_startup_mode <> 'USER' then
1329: --
1330: delete from hr_application_ownerships ao
1331: where ao.key_name = 'SUB_CLASSIFICATION_RULE_ID'
1332: and exists
1333: (select 1
1334: from pay_sub_classification_rules_f scr

Line 1459: delete from hr_application_ownerships ao

1455: if p_delete_mode = 'ZAP' then
1456: --
1457: if p_startup_mode <> 'USER' then
1458: --
1459: delete from hr_application_ownerships ao
1460: where ao.key_name = 'INPUT_VALUE_ID'
1461: and exists
1462: (select 1
1463: from pay_input_values_f iv

Line 1586: insert into hr_application_ownerships

1582: if g_debug then
1583: hr_utility.set_location('ins_ownerships', 1);
1584: end if;
1585: --
1586: insert into hr_application_ownerships
1587: (key_name,
1588: key_value,
1589: product_name)
1590: select p_key_name,

Line 1593: from hr_application_ownerships ao

1589: product_name)
1590: select p_key_name,
1591: p_key_value,
1592: ao.product_name
1593: from hr_application_ownerships ao
1594: where ao.key_name = 'ELEMENT_TYPE_ID'
1595: and ao.key_value = p_element_type_id;
1596: --
1597: if SQL%NOTFOUND then