DBA Data[Home] [Help]

APPS.PAY_ESU_BUS dependencies on PAY_TIME_SPANS

Line 391: -- Validates that the time span id exists in pay_time_spans.

387: -- -------------------------------------------------------------------------
388: -- {Start Of Comments}
389: --
390: -- Description:
391: -- Validates that the time span id exists in pay_time_spans.
392: --
393: -- Prerequisites:
394: -- None.
395: --

Line 431: from pay_time_spans pts

427: -- Cursor to check that a retro component exists.
428: --
429: cursor csr_time_span is
430: select null
431: from pay_time_spans pts
432: ,pay_retro_component_usages rcu
433: where pts.time_span_id = p_time_span_id
434: and rcu.retro_component_usage_id = p_retro_component_usage_id
435: and pts.creator_type = 'RC'