DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on FND_LOOKUPS

Line 999: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_TYPE';

995: ,p_effective_date in date) is
996: l_proc varchar2(72) := g_package||'chk_employer_type';
997: l_no_lookup boolean;
998: l_effective_date date := p_effective_date;
999: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_TYPE';
1000: l_lookup_code per_previous_employers.employer_type%type
1001: := p_employer_type;
1002: l_api_updating boolean;
1003: begin

Line 1092: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_SUBTYPE';

1088: --
1089: l_proc varchar2(72) := g_package||'chk_employer_subtype';
1090: l_no_lookup boolean;
1091: l_effective_date date := p_effective_date;
1092: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_SUBTYPE';
1093: l_lookup_code fnd_lookups.lookup_code%type := p_employer_subtype;
1094: l_employer_subtype hr_leg_lookups.lookup_code%type;
1095: --
1096: l_api_updating boolean;

Line 1093: l_lookup_code fnd_lookups.lookup_code%type := p_employer_subtype;

1089: l_proc varchar2(72) := g_package||'chk_employer_subtype';
1090: l_no_lookup boolean;
1091: l_effective_date date := p_effective_date;
1092: l_lookup_type fnd_lookups.lookup_type%type := 'PREV_EMP_SUBTYPE';
1093: l_lookup_code fnd_lookups.lookup_code%type := p_employer_subtype;
1094: l_employer_subtype hr_leg_lookups.lookup_code%type;
1095: --
1096: l_api_updating boolean;
1097: begin