DBA Data[Home] [Help]

APPS.PA_RBS_UTILS dependencies on PA_RBS_VERSIONS_B

Line 17: from pa_rbs_versions_b ver1

13: IF p_rbs_header_id IS NOT NULL THEN
14: BEGIN
15: select rbs_version_id
16: into l_version_id
17: from pa_rbs_versions_b ver1
18: where ver1.rbs_header_id = p_rbs_header_id
19: and ver1.current_reporting_flag = 'Y';
20: -- sysdate join?
21: EXCEPTION

Line 2759: INSERT INTO PA_RBS_VERSIONS_B (

2755: SELECT PA_RBS_VERSIONS_S.nextval
2756: INTO l_rbs_version_id from dual;
2757: l_Rbs_Version_From_Id := l_rbs_version_id;
2758:
2759: INSERT INTO PA_RBS_VERSIONS_B (
2760: RBS_VERSION_ID,
2761: VERSION_NUMBER,
2762: RBS_HEADER_ID,
2763: VERSION_START_DATE,

Line 3605: INSERT INTO PA_RBS_VERSIONS_B (

3601:
3602: SELECT PA_RBS_VERSIONS_S.nextval
3603: INTO l_rbs_version_id from dual;
3604:
3605: INSERT INTO PA_RBS_VERSIONS_B (
3606: RBS_VERSION_ID,
3607: VERSION_NUMBER,
3608: RBS_HEADER_ID,
3609: VERSION_START_DATE,