APPS.AR_ARXPOMR_XMLP_PKG dependencies on FND_PROFILE_OPTIONS

Line 82: FROM fnd_profile_options fpo,

78: begin
79: begin
80: SELECT fpo.profile_option_id
81: INTO l_po_id
82: FROM fnd_profile_options fpo,
83: fnd_profile_options_tl fpo_tl
84: WHERE
85: fpo.profile_option_name = 'ORG_ID'
86: AND fpo.profile_option_name = fpo_tl.profile_option_name

Line 83: fnd_profile_options_tl fpo_tl

79: begin
80: SELECT fpo.profile_option_id
81: INTO l_po_id
82: FROM fnd_profile_options fpo,
83: fnd_profile_options_tl fpo_tl
84: WHERE
85: fpo.profile_option_name = 'ORG_ID'
86: AND fpo.profile_option_name = fpo_tl.profile_option_name
87: AND fpo_tl.language = USERENV('LANG');

Line 107: FROM fnd_profile_options fpo,

103:
104: begin
105: SELECT fpo.profile_option_id
106: INTO l_po_id
107: FROM fnd_profile_options fpo,
108: fnd_profile_options_tl fpo_tl
109: WHERE
110: fpo.profile_option_name = 'ORG_ID'
111: AND fpo.profile_option_name = fpo_tl.profile_option_name

Line 108: fnd_profile_options_tl fpo_tl

104: begin
105: SELECT fpo.profile_option_id
106: INTO l_po_id
107: FROM fnd_profile_options fpo,
108: fnd_profile_options_tl fpo_tl
109: WHERE
110: fpo.profile_option_name = 'ORG_ID'
111: AND fpo.profile_option_name = fpo_tl.profile_option_name
112: AND fpo_tl.language = USERENV('LANG');

Line 147: FROM fnd_profile_options fpo,

143: begin
144:
145: SELECT fpo_tl.user_profile_option_name
146: INTO l_po_user_name
147: FROM fnd_profile_options fpo,
148: fnd_profile_options_tl fpo_tl
149: WHERE
150: fpo.profile_option_name =po_name
151: AND fpo.profile_option_name = fpo_tl.profile_option_name

Line 148: fnd_profile_options_tl fpo_tl

144:
145: SELECT fpo_tl.user_profile_option_name
146: INTO l_po_user_name
147: FROM fnd_profile_options fpo,
148: fnd_profile_options_tl fpo_tl
149: WHERE
150: fpo.profile_option_name =po_name
151: AND fpo.profile_option_name = fpo_tl.profile_option_name
152: AND fpo_tl.language = USERENV('LANG')