DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_LOOKUPS

Line 35: l_planning_level pa_lookups.meaning%type;

31:
32: function get_lookup_planning_level
33: (p_planning_level_code IN pa_proj_fp_options.all_fin_plan_level_code%TYPE)
34: return VARCHAR2 is
35: l_planning_level pa_lookups.meaning%type;
36: BEGIN
37: select meaning
38: into l_planning_level
39: from pa_lookups

Line 39: from pa_lookups

35: l_planning_level pa_lookups.meaning%type;
36: BEGIN
37: select meaning
38: into l_planning_level
39: from pa_lookups
40: where lookup_type = 'BUDGET ENTRY LEVEL' and
41: lookup_code = p_planning_level_code;
42: return l_planning_level;
43: END get_lookup_planning_level;

Line 48: l_time_phase pa_lookups.meaning%type;

44:
45: function get_lookup_time_phase
46: (p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE)
47: return VARCHAR2 is
48: l_time_phase pa_lookups.meaning%type;
49: BEGIN
50: select meaning
51: into l_time_phase
52: from pa_lookups

Line 52: from pa_lookups

48: l_time_phase pa_lookups.meaning%type;
49: BEGIN
50: select meaning
51: into l_time_phase
52: from pa_lookups
53: where lookup_type = 'BUDGET TIME PHASED TYPE' and
54: lookup_code = p_time_phased_code;
55: return l_time_phase;
56: END get_lookup_time_phase;