APPS.INVPVHDR dependencies on FND_ID_FLEX_SEGMENTS

Line 427: from FND_ID_FLEX_SEGMENTS FS

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

Line 438: from FND_ID_FLEX_SEGMENTS FS

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

Line 466: from FND_ID_FLEX_SEGMENTS FS

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