eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CORE_UTILS dependencies on PAY_UPGRADE_DEFINITIONS

Line 1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;

1994: p_status out nocopy varchar2,
1995: p_raise_error in boolean default TRUE)
1996: is
1997: --
1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;
1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;

Line 1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;

1995: p_raise_error in boolean default TRUE)
1996: is
1997: --
1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;
1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;

Line 2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;

1996: is
1997: --
1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;
1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;

Line 2001: l_failure_point pay_upgrade_definitions.failure_point%type;

1997: --
1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;
1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;
2005: l_upgrade_status pay_upgrade_status.status%type;

Line 2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;

1998: l_upgrade_definition_id pay_upgrade_definitions.upgrade_definition_id%type;
1999: l_legislation_code pay_upgrade_definitions.legislation_code%type;
2000: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
2001: l_failure_point pay_upgrade_definitions.failure_point%type;
2002: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
2003: l_bg_leg_code per_business_groups.legislation_code%type;
2004: l_status pay_upgrade_status.status%type;
2005: l_upgrade_status pay_upgrade_status.status%type;
2006: l_check_upgrade boolean;

Line 2022: from pay_upgrade_definitions pud

2018: l_legislation_code,
2019: l_upgrade_level,
2020: l_failure_point,
2021: l_legislatively_enabled
2022: from pay_upgrade_definitions pud
2023: where pud.short_name = p_short_name;
2024: --
2025: -- Bugfix 3494732
2026: -- Only fetch the legislation_code when a non-null