DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 446: from fnd_descr_flex_contexts_vl

442: CURSOR csr_asg_loc_addr(p_location_id number) is
443: SELECT LOCATION_ID,
444: STYLE,
445: ( SELECT descriptive_flex_context_name
446: from fnd_descr_flex_contexts_vl
447: where descriptive_flexfield_name ='Address Structure'
448: AND descriptive_flex_context_code = STYLE) STYLE_DESC,
449: COUNTRY,
450: (SELECT TERRITORY_SHORT_NAME FROM FND_TERRITORIES_VL WHERE TERRITORY_CODE = COUNTRY) COUNTRY_DESC,

Line 556: from fnd_descr_flex_contexts_vl

552: , to_char(DATE_FROM,'YYYY-MM-DD')
553: , PRIMARY_FLAG
554: , STYLE
555: , ( SELECT descriptive_flex_context_name
556: from fnd_descr_flex_contexts_vl
557: where descriptive_flexfield_name ='Address Structure'
558: AND descriptive_flex_context_code = STYLE) STYLE_DESC
559: , ADDRESS_LINE1
560: , ADDRESS_LINE2

Line 628: from fnd_descr_flex_contexts_vl

624: , to_char(DATE_FROM,'YYYY-MM-DD')
625: , PRIMARY_FLAG
626: , STYLE
627: , ( SELECT descriptive_flex_context_name
628: from fnd_descr_flex_contexts_vl
629: where descriptive_flexfield_name ='Address Structure'
630: AND descriptive_flex_context_code = STYLE) STYLE_DESC
631: , ADDRESS_LINE1
632: , ADDRESS_LINE2