DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_RBS_VERSIONS_B

Line 2763: pa_rbs_versions_b ver1

2759: ver1.rbs_version_id as rbs_version_id,
2760: ver1.rbs_header_id as rbs_header_id
2761: FROM pa_rbs_headers_b hdrb,
2762: pa_rbs_headers_tl hdrtl,
2763: pa_rbs_versions_b ver1
2764: WHERE sysdate between hdrb.effective_from_date and nvl(hdrb.effective_to_date,sysdate)
2765: AND hdrtl.rbs_header_id = hdrb.rbs_header_id
2766: AND hdrtl.language = USERENV('LANG')
2767: AND ver1.rbs_header_id = hdrtl.rbs_header_id

Line 2770: from pa_rbs_versions_b ver2

2766: AND hdrtl.language = USERENV('LANG')
2767: AND ver1.rbs_header_id = hdrtl.rbs_header_id
2768: /*** 3711762
2769: AND ver1.version_number = (select max(version_number)
2770: from pa_rbs_versions_b ver2
2771: where ver1.rbs_header_id =
2772: ver2.rbs_header_id
2773: and ver2.status_code = 'FROZEN')
2774: 3711762 ***/