DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_RBS_VERSIONS_B

Line 2808: pa_rbs_versions_b ver1

2804: ver1.rbs_version_id as rbs_version_id,
2805: ver1.rbs_header_id as rbs_header_id
2806: FROM pa_rbs_headers_b hdrb,
2807: pa_rbs_headers_tl hdrtl,
2808: pa_rbs_versions_b ver1
2809: WHERE sysdate between hdrb.effective_from_date and nvl(hdrb.effective_to_date,sysdate)
2810: AND hdrtl.rbs_header_id = hdrb.rbs_header_id
2811: AND hdrtl.language = USERENV('LANG')
2812: AND ver1.rbs_header_id = hdrtl.rbs_header_id

Line 2815: from pa_rbs_versions_b ver2

2811: AND hdrtl.language = USERENV('LANG')
2812: AND ver1.rbs_header_id = hdrtl.rbs_header_id
2813: /*** 3711762
2814: AND ver1.version_number = (select max(version_number)
2815: from pa_rbs_versions_b ver2
2816: where ver1.rbs_header_id =
2817: ver2.rbs_header_id
2818: and ver2.status_code = 'FROZEN')
2819: 3711762 ***/