APPS.PJM_SEIBAN_PUB dependencies on PJM_SEIBAN_NUMBERS

Line 23: FROM ( SELECT project_id , project_number FROM pjm_seiban_numbers

19: ) IS
20:
21: CURSOR v1 IS
22: SELECT s.project_id
23: FROM ( SELECT project_id , project_number FROM pjm_seiban_numbers
24: UNION ALL
25: SELECT project_id , segment1 FROM pa_projects_all ) s
26: WHERE s.project_number = P_seiban_number;
27:

Line 30: FROM ( SELECT project_id , project_name FROM pjm_seiban_numbers

26: WHERE s.project_number = P_seiban_number;
27:
28: CURSOR v2 IS
29: SELECT s.project_id
30: FROM ( SELECT project_id , project_name FROM pjm_seiban_numbers
31: UNION ALL
32: SELECT project_id , name FROM pa_projects_all ) s
33: WHERE s.project_name = P_seiban_name;
34:

Line 144: , desc_flex_name => 'PJM_SEIBAN_NUMBERS'

140:
141:
142: IF NOT FND_FLEX_DESCVAL.validate_desccols
143: ( appl_short_name => 'PJM'
144: , desc_flex_name => 'PJM_SEIBAN_NUMBERS'
145: , values_or_ids => 'I' ) THEN
146:
147: FND_MSG_PUB.add_exc_msg
148: ( p_pkg_name => G_PKG_NAME

Line 246: INSERT INTO pjm_seiban_numbers

242: END IF;
243:
244: SELECT pa_projects_s.nextval INTO l_project_id FROM dual;
245:
246: INSERT INTO pjm_seiban_numbers
247: ( project_id
248: , project_number
249: , project_name
250: , operating_unit