DBA Data[Home] [Help]

APPS.PER_DATA_UPDATE_REPORT dependencies on PAY_UPGRADE_PARAMETERS

Line 13: from pay_upgrade_parameters

9: is
10: cursor csr_get_parameter_value(f_parameter_name varchar2,
11: f_upgrade_definition_id number) is
12: select parameter_value
13: from pay_upgrade_parameters
14: where parameter_name = f_parameter_name
15: and upgrade_definition_id = f_upgrade_definition_id;
16:
17: l_parameter_value pay_upgrade_parameters.parameter_value%type;

Line 17: l_parameter_value pay_upgrade_parameters.parameter_value%type;

13: from pay_upgrade_parameters
14: where parameter_name = f_parameter_name
15: and upgrade_definition_id = f_upgrade_definition_id;
16:
17: l_parameter_value pay_upgrade_parameters.parameter_value%type;
18:
19: begin
20: open csr_get_parameter_value(f_parameter_name, f_upgrade_definition_id);
21: fetch csr_get_parameter_value into l_parameter_value;