APPS.PAY_CORE_UTILS dependencies on PAY_UPGRADE_STATUS

Line 1891: l_status pay_upgrade_status.status%type;

1887: l_upgrade_level pay_upgrade_definitions.upgrade_level%type;
1888: l_failure_point pay_upgrade_definitions.failure_point%type;
1889: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
1890: l_bg_leg_code per_business_groups.legislation_code%type;
1891: l_status pay_upgrade_status.status%type;
1892: l_upgrade_status pay_upgrade_status.status%type;
1893: l_check_upgrade boolean;
1894: l_dummy number;
1895: --

Line 1892: l_upgrade_status pay_upgrade_status.status%type;

1888: l_failure_point pay_upgrade_definitions.failure_point%type;
1889: l_legislatively_enabled pay_upgrade_definitions.legislatively_enabled%type;
1890: l_bg_leg_code per_business_groups.legislation_code%type;
1891: l_status pay_upgrade_status.status%type;
1892: l_upgrade_status pay_upgrade_status.status%type;
1893: l_check_upgrade boolean;
1894: l_dummy number;
1895: --
1896: begin

Line 1975: from pay_upgrade_status pus

1971: begin
1972: --
1973: select pus.status
1974: into l_upgrade_status
1975: from pay_upgrade_status pus
1976: where pus.upgrade_definition_id = l_upgrade_definition_id
1977: and pus.business_group_id = p_bus_grp_id;
1978: --
1979: if (l_upgrade_status = 'C') then

Line 2014: from pay_upgrade_status pus

2010: begin
2011: --
2012: select pus.status
2013: into l_upgrade_status
2014: from pay_upgrade_status pus
2015: where pus.upgrade_definition_id = l_upgrade_definition_id
2016: and pus.legislation_code = l_bg_leg_code;
2017: --
2018: if (l_upgrade_status = 'C') then

Line 2053: from pay_upgrade_status pus

2049: begin
2050: --
2051: select pus.status
2052: into l_upgrade_status
2053: from pay_upgrade_status pus
2054: where pus.upgrade_definition_id = l_upgrade_definition_id
2055: and pus.legislation_code is null
2056: and pus.business_group_id is null;
2057: --

Line 2116: l_status pay_upgrade_status.status%type;

2112: p_bus_grp_id in number,
2113: p_short_name in varchar2,
2114: p_raise_error in varchar2 default 'TRUE') return varchar2
2115: is
2116: l_status pay_upgrade_status.status%type;
2117: begin
2118: get_upgrade_status(
2119: p_bus_grp_id => p_bus_grp_id,
2120: p_short_name => p_short_name,