DBA Data[Home] [Help]

APPS.RRS_SITE_INFO dependencies on FND_TIMEZONES_VL

Line 1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,

1674: PHONE_LINE_TYPE HZ_CONTACT_POINTS.PHONE_LINE_TYPE%Type,
1675: CONTENT_SOURCE_TYPE HZ_CONTACT_POINTS.CONTENT_SOURCE_TYPE%Type,
1676: RAW_PHONE_NUMBER HZ_CONTACT_POINTS.RAW_PHONE_NUMBER%Type,
1677: TIMEZONE_ID HZ_CONTACT_POINTS.TIMEZONE_ID%Type,
1678: TIMEZONE_NAME FND_TIMEZONES_VL.NAME%Type,
1679: CONTACT_POINT_PURPOSE HZ_CONTACT_POINTS.CONTACT_POINT_PURPOSE%Type,
1680: PRIMARY_BY_PURPOSE HZ_CONTACT_POINTS.PRIMARY_BY_PURPOSE%Type,
1681: TRANSPOSED_PHONE_NUMBER HZ_CONTACT_POINTS.TRANSPOSED_PHONE_NUMBER%Type,
1682: ACTUAL_CONTENT_SOURCE HZ_CONTACT_POINTS.ACTUAL_CONTENT_SOURCE%Type

Line 1896: ,FND_TIMEZONES_VL Ftv

1892: BULK COLLECT
1893: INTO l_phone_details
1894: FROM
1895: HZ_CONTACT_POINTS HzPuiContactPointPhoneEO
1896: ,FND_TIMEZONES_VL Ftv
1897: WHERE (CONTACT_POINT_TYPE = 'PHONE' and
1898: OWNER_TABLE_NAME = 'HZ_PARTIES' AND OWNER_TABLE_ID = l_site_party_id
1899: AND Ftv.ENABLED_FLAG(+) = 'Y'
1900: AND HzPuiContactPointPhoneEO.TIMEZONE_ID = Ftv.UPGRADE_TZ_ID(+)