APPS.PAY_SUB_CLASS_RULES_PKG dependencies on HR_APPLICATION_OWNERSHIPS

Line 100: insert into hr_application_ownerships

96: -- application ownerships where a user enters a value on the form, but
97: -- this code is intended to handle third party insertion from the element
98: --
99: hr_utility.set_location ('PAY_SUB_CLASS_RULES_PKG.INSERT_ROW',4);
100: insert into hr_application_ownerships
101: (key_name,
102: key_value,
103: product_name)
104: select 'SUB_CLASSIFICATION_RULE_ID',

Line 107: from hr_application_ownerships ao

103: product_name)
104: select 'SUB_CLASSIFICATION_RULE_ID',
105: p_sub_classification_rule_id,
106: ao.product_name
107: from hr_application_ownerships ao
108: where ao.key_name = 'ELEMENT_TYPE_ID'
109: and ao.key_value = p_element_type_id
110: and not exists (select 'SUB_CLASSIFICATION_RULE_ID',
111: p_sub_classification_rule_id,

Line 113: from hr_application_ownerships ao

109: and ao.key_value = p_element_type_id
110: and not exists (select 'SUB_CLASSIFICATION_RULE_ID',
111: p_sub_classification_rule_id,
112: ao.product_name
113: from hr_application_ownerships ao
114: where ao.key_name = 'ELEMENT_TYPE_ID'
115: and ao.key_value = p_element_type_id);
116: --
117: end if;

Line 417: delete from hr_application_ownerships

413: hr_utility.set_message_token('STEP','2');
414: hr_utility.raise_error;
415: end if;
416: --
417: delete from hr_application_ownerships
418: where key_name = 'SUB_CLASSIFICATION_RULE_ID'
419: and key_value = p_sub_classification_rule_id;
420: --
421: end delete_row;