APPS.PA_FIN_PLAN_CREATE_VER_GLOBAL dependencies on PA_PROJ_PERIOD_PROFILES

Line 75: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)

71: 9/11/02 ADDED FUNCTIONS TO RETRIEVE GL/PA START/END PERIOD
72: NAMES FOR CREATE VERSION PAGE
73: ============================================================== */
74: FUNCTION get_gl_current_start_period
75: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
76: return VARCHAR2 is
77:
78: cursor l_csr is
79: select period_name1

Line 80: from pa_proj_period_profiles

76: return VARCHAR2 is
77:
78: cursor l_csr is
79: select period_name1
80: from pa_proj_period_profiles
81: where project_id = p_project_id and
82: plan_period_type = 'GL' and
83: current_flag = 'Y';
84: l_rec l_csr%ROWTYPE;

Line 98: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)

94: END get_gl_current_start_period;
95:
96:
97: FUNCTION get_gl_current_end_period
98: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
99: return VARCHAR2 is
100: cursor l_csr is
101: select profile_end_period_name
102: from pa_proj_period_profiles

Line 102: from pa_proj_period_profiles

98: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
99: return VARCHAR2 is
100: cursor l_csr is
101: select profile_end_period_name
102: from pa_proj_period_profiles
103: where project_id = p_project_id and
104: plan_period_type = 'GL' and
105: current_flag = 'Y';
106: l_rec l_csr%ROWTYPE;

Line 120: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)

116: END get_gl_current_end_period;
117:
118:
119: FUNCTION get_pa_current_start_period
120: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
121: return VARCHAR2 is
122: cursor l_csr is
123: select period_name1
124: from pa_proj_period_profiles

Line 124: from pa_proj_period_profiles

120: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
121: return VARCHAR2 is
122: cursor l_csr is
123: select period_name1
124: from pa_proj_period_profiles
125: where project_id = p_project_id and
126: plan_period_type = 'PA' and
127: current_flag = 'Y';
128: l_rec l_csr%ROWTYPE;

Line 142: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)

138: END get_pa_current_start_period;
139:
140:
141: FUNCTION get_pa_current_end_period
142: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
143: return VARCHAR2 is
144: cursor l_csr is
145: select profile_end_period_name
146: from pa_proj_period_profiles

Line 146: from pa_proj_period_profiles

142: (p_project_id IN pa_proj_period_profiles.project_id%TYPE)
143: return VARCHAR2 is
144: cursor l_csr is
145: select profile_end_period_name
146: from pa_proj_period_profiles
147: where project_id = p_project_id and
148: plan_period_type = 'PA' and
149: current_flag = 'Y';
150: l_rec l_csr%ROWTYPE;