APPS.PER_SG_PERWSEPI dependencies on FND_TERRITORIES_VL

Line 48: (p_country_code in fnd_territories_vl.territory_code%type,

44: -- the main Person (PERWSEPI) and Combined Assignment (PERWSHRG) forms.
45: -- Selects ALL the values to be seen by the user, according to the codes.
46: ---------------------------------------------------------------------------
47: procedure get_pddf_lookup_meanings
48: (p_country_code in fnd_territories_vl.territory_code%type,
49: p_permit_type_code in hr_lookups.lookup_code%type,
50: p_permit_category_code in hr_lookups.lookup_code%type,
51: p_nric_colour_code in hr_lookups.lookup_code%type,
52: p_religion_code in hr_lookups.lookup_code%type,

Line 58: p_country out nocopy fnd_territories_vl.territory_short_name%type,

54: p_race_code in hr_lookups.lookup_code%type,
55: p_community_fund_code in hr_lookups.lookup_code%type,
56: p_ee_er_rate_code in hr_lookups.lookup_code%type,
57: p_payee_id_type_code in hr_lookups.lookup_code%type,
58: p_country out nocopy fnd_territories_vl.territory_short_name%type,
59: p_permit_type out nocopy hr_lookups.meaning%type,
60: p_permit_category out nocopy hr_lookups.meaning%type,
61: p_nric_colour out nocopy hr_lookups.meaning%type,
62: p_religion out nocopy hr_lookups.meaning%type,

Line 73: (c_territory_code fnd_territories_vl.territory_code%type) is

69:
70: l_meaning hr_lookups.meaning%type;
71:
72: cursor sg_countries
73: (c_territory_code fnd_territories_vl.territory_code%type) is
74: select territory_short_name
75: from fnd_territories_vl
76: where territory_code = c_territory_code;
77:

Line 75: from fnd_territories_vl

71:
72: cursor sg_countries
73: (c_territory_code fnd_territories_vl.territory_code%type) is
74: select territory_short_name
75: from fnd_territories_vl
76: where territory_code = c_territory_code;
77:
78: cursor sg_lookups
79: (c_lookup_type hr_lookups.lookup_type%type,