[Home] [Help]
APPS.PAY_RETRO_STATUS_INTERNAL dependencies on PAY_RETRO_COMPONENT_USAGES
Line 998: l_legislation_code pay_retro_component_usages.legislation_code%type;
994: -- Declare local variables
995: --
996: l_proc varchar2(72) := g_package||'chk_retro_component_id';
997: l_exists number;
998: l_legislation_code pay_retro_component_usages.legislation_code%type;
999:
1000: --
1001: -- Cursor to check that a retro component exists.
1002: --
Line 1080: pay_retro_component_usages rcu
1076: cursor csr_rcu
1077: is
1078: select 1
1079: from
1080: pay_retro_component_usages rcu
1081: where
1082: rcu.creator_id = p_element_type_id
1083: and rcu.creator_type = 'ET'
1084: and rcu.retro_component_id = p_retro_component_id