DBA Data[Home] [Help]

APPS.PER_RI_CONFIG_UTILITIES dependencies on FND_ID_FLEX_STRUCTURES_VL

Line 1942: from fnd_application fa, fnd_id_flex_structures_vl fifs

1938: ,p_structure_code in varchar2) IS
1939:
1940: cursor flex_num_cursor IS
1941: select fifs.id_flex_num
1942: from fnd_application fa, fnd_id_flex_structures_vl fifs
1943: where fa.application_short_name = p_appl_short_name
1944: and fa.application_id = fifs.application_id
1945: and fifs.id_flex_code = p_flex_code
1946: and fifs.id_flex_structure_code = p_structure_code;

Line 1954: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;

1950: l_log_message varchar2(360);
1951: l_flexfield fnd_flex_key_api.flexfield_type;
1952: l_structure fnd_flex_key_api.structure_type;
1953: l_new_structure fnd_flex_key_api.structure_type;
1954: l_id_flex_num fnd_id_flex_structures_vl.id_flex_num%type;
1955: l_request_id number(9);
1956:
1957: BEGIN
1958: hr_utility.set_location('Entering:'|| l_proc, 10);