APPS.PAY_ESU_BUS dependencies on PAY_RETRO_COMPONENT_USAGES

Line 299: -- pay_retro_component_usages.

295: -- {Start Of Comments}
296: --
297: -- Description:
298: -- Validates that the retro component usage id exists in
299: -- pay_retro_component_usages.
300: --
301: -- Prerequisites:
302: -- None.
303: --

Line 342: from pay_retro_component_usages

338: -- Cursor to check that a retro component exists.
339: --
340: cursor csr_retro_component_usage is
341: select null
342: from pay_retro_component_usages
343: where retro_component_usage_id = p_retro_component_usage_id
344: and nvl(legislation_code, nvl(l_legislation_code, l_varchar2))
345: = nvl(l_legislation_code, l_varchar2)
346: and nvl(business_group_id, nvl(p_business_group_id, l_number))

Line 432: ,pay_retro_component_usages rcu

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'
436: and pts.creator_id = rcu.retro_component_id;