DBA Data[Home] [Help]

APPS.PSB_PAY_ELEMENT_OPTIONS_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 306: --from psb_pay_element_rates to maintain the isolated delete

302: FND_MSG_PUB.initialize;
303: end if;
304:
305: --Deleting detail record from psb_pay_element_options and
306: --from psb_pay_element_rates to maintain the isolated delete
307: --relation between the master and detail
308:
309: DELETE FROM psb_pay_element_rates
310: WHERE pay_element_option_id = p_pay_element_option_id

Line 309: DELETE FROM psb_pay_element_rates

305: --Deleting detail record from psb_pay_element_options and
306: --from psb_pay_element_rates to maintain the isolated delete
307: --relation between the master and detail
308:
309: DELETE FROM psb_pay_element_rates
310: WHERE pay_element_option_id = p_pay_element_option_id
311: AND pay_element_id = p_pay_element_id;
312:
313: --Delete the record in the master table