DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on FND_LOOKUPS

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

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

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

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

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

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