APPS.PAY_UPGRADE_LEGISLATIONS_PKG dependencies on PAY_UPGRADE_DEFINITIONS

Line 61: l_legislatively_enabled PAY_UPGRADE_DEFINITIONS.LEGISLATIVELY_ENABLED%TYPE;

57:
58: PROCEDURE chk_upgrade_definition_id( p_upgrade_definition_id in number )
59: is
60: --
61: l_legislatively_enabled PAY_UPGRADE_DEFINITIONS.LEGISLATIVELY_ENABLED%TYPE;
62: l_proc varchar2(100) := g_package || 'chk_upgrade_definition_id';
63: --
64: cursor csr_upgrade_definition is
65: select legislatively_enabled

Line 66: from pay_upgrade_definitions

62: l_proc varchar2(100) := g_package || 'chk_upgrade_definition_id';
63: --
64: cursor csr_upgrade_definition is
65: select legislatively_enabled
66: from pay_upgrade_definitions
67: where upgrade_definition_id = p_upgrade_definition_id ;
68: --
69: BEGIN
70: --

Line 319: from pay_upgrade_definitions pud, pay_upgrade_legislations pul

315: l_last_update_date PAY_UPGRADE_LEGISLATIONS.LAST_UPDATE_DATE%TYPE;
316:
317: cursor csr_existing is
318: select pul.upgrade_definition_id
319: from pay_upgrade_definitions pud, pay_upgrade_legislations pul
320: where upper(pud.short_name) = upper(p_short_name)
321: and pud.upgrade_definition_id = pul.upgrade_definition_id
322: and pul.legislation_code = p_legislation_code;
323:

Line 326: from pay_upgrade_definitions pud

322: and pul.legislation_code = p_legislation_code;
323:
324: cursor csr_upgrade_definition_id is
325: select pud.upgrade_definition_id
326: from pay_upgrade_definitions pud
327: where upper(pud.short_name) = upper(p_short_name);
328:
329: --
330: BEGIN