APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PAY_UPGRADE_STATUS

Line 23: l_upgrade_status pay_upgrade_status.status%type;

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,

Line 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

Line 2869: from pay_upgrade_status

2865: and legislation_code = p_legislation_code;
2866: --
2867: cursor csr_upgrade_status(p_upgrade_definition_id number) is
2868: select status
2869: from pay_upgrade_status
2870: where upgrade_definition_id = p_upgrade_definition_id
2871: and business_group_id is null
2872: and legislation_code = p_legislation_code;
2873: --