APPS.INVPVHDR dependencies on FND_ID_FLEX_SEGMENTS

Line 429: from FND_ID_FLEX_SEGMENTS FS

425:
426: IF g_max_segment IS NULL THEN
427: select max(FS.segment_num)
428: into g_max_segment
429: from FND_ID_FLEX_SEGMENTS FS
430: where FS.APPLICATION_ID = l_application_id
431: and FS.id_flex_code = l_id_flex_code
432: and FS.ENABLED_FLAG = l_enabled_flag
433: and FS.id_flex_num = l_id_flex_num;

Line 440: from FND_ID_FLEX_SEGMENTS FS

436: max_segment := g_max_segment;
437:
438: IF g_totalsegs IS NULL THEN
439: select count(*) into g_totalsegs
440: from FND_ID_FLEX_SEGMENTS FS
441: where FS.APPLICATION_ID = l_application_id
442: and FS.id_flex_code = l_id_flex_code
443: and FS.ENABLED_FLAG = l_enabled_flag
444: and FS.id_flex_num = l_id_flex_num;

Line 468: from FND_ID_FLEX_SEGMENTS FS

464: ** to match the changes made in INVPUL1B.pls get_dynamic_sql_str
465: */
466: select to_number(substr(FS.application_column_name, 8))
467: into segnum
468: from FND_ID_FLEX_SEGMENTS FS
469: where FS.SEGMENT_NUM = n
470: and FS.ID_FLEX_CODE = l_id_flex_code
471: and FS.ID_FLEX_NUM = l_id_flex_num
472: and FS.ENABLED_FLAG = l_enabled_flag