APPS.HR_RATE_VALUES_SWI dependencies on HR_API_TRANSACTION_STEPS

Line 1017: delete from hr_api_transaction_steps

1013: if l_asg_rate_rec.transaction_step_id is not null
1014: then
1015: delete from hr_api_transaction_values
1016: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1017: delete from hr_api_transaction_steps
1018: where transaction_step_id = l_asg_rate_rec.transaction_step_id;
1019: end if;
1020: goto end_of_process;
1021: end if;

Line 1381: FROM hr_api_transaction_steps s,

1377: h.number_value object_version_number,
1378: i.number_value grade_rule_id,
1379: j.varchar2_value currency_code,
1380: to_char(s.transaction_step_id) transaction_step_id
1381: FROM hr_api_transaction_steps s,
1382: hr_api_transaction_values a, hr_api_transaction_values b,
1383: hr_api_transaction_values c, hr_api_transaction_values d,
1384: hr_api_transaction_values e, hr_api_transaction_values f,
1385: hr_api_transaction_values g, hr_api_transaction_values h,

Line 1430: FROM hr_api_transaction_steps s,

1426: WHERE pgr.rate_type = 'A'
1427: AND pgr.assignment_id = to_number(p_assignment_id)
1428: AND pgr.business_group_id = to_number(p_business_gp_id)
1429: AND pgr.grade_rule_id NOT IN (SELECT nvl(a.number_value, -1)
1430: FROM hr_api_transaction_steps s,
1431: hr_api_transaction_values a
1432: WHERE s.item_type = p_item_type
1433: AND s.item_key = p_item_key
1434: AND s.api_name = g_package||'.PROCESS_API'

Line 1669: delete from hr_api_transaction_steps

1665: ) is
1666: begin
1667: delete from hr_api_transaction_values
1668: where transaction_step_id = p_transaction_step_id;
1669: delete from hr_api_transaction_steps
1670: where transaction_step_id = p_transaction_step_id;
1671: end delete_transaction_step;
1672:
1673: FUNCTION is_date_change_required