DBA Data[Home] [Help]

APPS.HRDYNDBI dependencies on PER_ASSIGNMENT_INFO_TYPES

Line 6424: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;

6420: return varchar2 is
6421: --
6422: l_legislation_code hr_org_information_types.legislation_code%type;
6423: l_navigation_method hr_org_information_types.navigation_method%type;
6424: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6425: --
6426: begin
6427: --
6428: --

Line 6464: from per_assignment_info_types

6460: select legislation_code,
6461: multiple_occurences_flag
6462: into l_legislation_code,
6463: l_multi_occur_flag
6464: from per_assignment_info_types
6465: where information_type = p_context;
6466: --
6467: -- The database item generated can only return one row. So if the
6468: -- multiple occurrences flag is not 'N' then raise an error.

Line 6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;

6699: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6700: l_legislation_code hr_org_information_types.legislation_code%type;
6701: l_context hr_org_information_types.org_information_type%type;
6702: l_navigation_method hr_org_information_types.navigation_method%type;
6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6704: --
6705: -- declare a cursor to determine the routes to a descriptive flexfield's
6706: -- tables and an entity name for each of these tables.
6707: --

Line 6862: from per_assignment_info_types

6858: select legislation_code,
6859: multiple_occurences_flag
6860: into l_legislation_code,
6861: l_multi_occur_flag
6862: from per_assignment_info_types
6863: where information_type = p_context;
6864: --
6865: -- this check to see if the multiple_occurences_flag is 'N' is also
6866: -- performed in the concurrent program. It has been added here as