APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_OPINION_VALUES_B

Line 78: l_old_opinion_value_code amw_opinion_values_b.opinion_value_code%type;

74: x_change_flag OUT NOCOPY VARCHAR2
75: )
76: IS
77:
78: l_old_opinion_value_code amw_opinion_values_b.opinion_value_code%type;
79: l_new_opinion_value_code amw_opinion_values_b.opinion_value_code%type;
80:
81: CURSOR Get_Opinion_Value(p_opinion_log_id NUMBER)IS
82: SELECT OPINION_VALUE_CODE INTO l_old_opinion_value_code

Line 79: l_new_opinion_value_code amw_opinion_values_b.opinion_value_code%type;

75: )
76: IS
77:
78: l_old_opinion_value_code amw_opinion_values_b.opinion_value_code%type;
79: l_new_opinion_value_code amw_opinion_values_b.opinion_value_code%type;
80:
81: CURSOR Get_Opinion_Value(p_opinion_log_id NUMBER)IS
82: SELECT OPINION_VALUE_CODE INTO l_old_opinion_value_code
83: FROM AMW_OPINION_VALUES_B value,

Line 83: FROM AMW_OPINION_VALUES_B value,

79: l_new_opinion_value_code amw_opinion_values_b.opinion_value_code%type;
80:
81: CURSOR Get_Opinion_Value(p_opinion_log_id NUMBER)IS
82: SELECT OPINION_VALUE_CODE INTO l_old_opinion_value_code
83: FROM AMW_OPINION_VALUES_B value,
84: AMW_OPINION_LOG_DETAILS detail,
85: AMW_OPINION_COMPONTS_B comp
86: WHERE detail.opinion_log_id = p_opinion_log_id
87: AND detail.opinion_component_id = comp.opinion_component_id