APPS.PAY_ITERATE dependencies on HR_APPLICATION_OWNERSHIPS

Line 979: -- also need to delete the row in hr_application_ownerships, else will get

975: where run_type_id = p_rt_id
976: and language = each_row.language_code;
977: end loop;
978: --
979: -- also need to delete the row in hr_application_ownerships, else will get
980: -- a unique contraint error
981: --
982: l_sess := nvl(hr_startup_data_api_support.g_startup_session_id
983: ,hr_startup_data_api_support.g_session_id);

Line 986: delete from hr_application_ownerships

982: l_sess := nvl(hr_startup_data_api_support.g_startup_session_id
983: ,hr_startup_data_api_support.g_session_id);
984: --
985: for each_row in get_prods(l_sess) loop
986: delete from hr_application_ownerships
987: where key_name = 'RUN_TYPE_ID'
988: and key_value = p_rt_id
989: and product_name = each_row.product_short_name;
990: end loop;