APPS.HRI_OLTP_PMV_TRN_BCKT_GRAPH dependencies on HRI_OLTP_VIEW_MESSAGE

Line 166: ''NA_OTHERS'', ''' || hri_oltp_view_message.get_others_msg || ''',

162: l_SQLText :=
163: 'SELECT -- Terminations by Job Function (Top 5)
164: qry.vby_id VIEWBYID
165: ,DECODE(qry.grp_id,
166: ''NA_OTHERS'', ''' || hri_oltp_view_message.get_others_msg || ''',
167: cl.value) VIEWBY
168: ,qry.curr_separation_hdc HRI_P_MEASURE1
169: ,DECODE(qry.grp_id, ''NA_OTHERS'', '''', ''' || l_drill_url1 || ''')
170: HRI_P_DRILL_URL1

Line 298: ''NA_OTHERS'', ''' || hri_oltp_view_message.get_others_msg || ''',

294: 'SELECT
295: -- Terminations by Leaving Reason (Top 5)
296: qry.vby_id VIEWBYID
297: ,DECODE(qry.grp_id,
298: ''NA_OTHERS'', ''' || hri_oltp_view_message.get_others_msg || ''',
299: cl.value) VIEWBY
300: ,qry.curr_separation_hdc HRI_P_MEASURE1
301: ,DECODE(qry.grp_id, ''NA_OTHERS'', '''', ''' || l_drill_url1 ||''')
302: HRI_P_DRILL_URL1