19: function get_upgrade_status(
20: p_upgrade_short_name in varchar2,
21: p_legislation_code in varchar2) return varchar2
22: is
23: l_upgrade_status pay_upgrade_status.status%type;
24: --
25: cursor csr_upgrade_status is
26: select status
27: from pay_upgrade_status s,
23: l_upgrade_status pay_upgrade_status.status%type;
24: --
25: cursor csr_upgrade_status is
26: select status
27: from pay_upgrade_status s,
28: pay_upgrade_definitions d
29: where d.short_name = p_upgrade_short_name
30: and s.upgrade_definition_id = d.upgrade_definition_id
31: -- and s.business_group_id is null
2339: and legislation_code = p_legislation_code;
2340: --
2341: cursor csr_upgrade_status(p_upgrade_definition_id number) is
2342: select status
2343: from pay_upgrade_status
2344: where upgrade_definition_id = p_upgrade_definition_id
2345: and business_group_id is null
2346: and legislation_code = p_legislation_code;
2347: --