eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_SG_PERWSEPI dependencies on HR_LOOKUPS

Line 49: p_permit_type_code in hr_lookups.lookup_code%type,

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,
53: p_cpf_category_code in hr_lookups.lookup_code%type,

Line 50: p_permit_category_code in hr_lookups.lookup_code%type,

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,
53: p_cpf_category_code in hr_lookups.lookup_code%type,
54: p_race_code in hr_lookups.lookup_code%type,

Line 51: p_nric_colour_code in hr_lookups.lookup_code%type,

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,
53: p_cpf_category_code in hr_lookups.lookup_code%type,
54: p_race_code in hr_lookups.lookup_code%type,
55: p_community_fund_code in hr_lookups.lookup_code%type,

Line 52: p_religion_code in hr_lookups.lookup_code%type,

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,
53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 53: p_cpf_category_code in hr_lookups.lookup_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,
53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 54: p_race_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,
53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 55: p_community_fund_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,
53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 56: p_ee_er_rate_code in hr_lookups.lookup_code%type,

52: p_religion_code in hr_lookups.lookup_code%type,
53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 57: p_payee_id_type_code in hr_lookups.lookup_code%type,

53: p_cpf_category_code in hr_lookups.lookup_code%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,

Line 59: p_permit_type out nocopy hr_lookups.meaning%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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,

Line 60: p_permit_category out nocopy hr_lookups.meaning%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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,

Line 61: p_nric_colour out nocopy hr_lookups.meaning%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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,

Line 62: p_religion out nocopy hr_lookups.meaning%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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,

Line 63: p_cpf_category out nocopy hr_lookups.meaning%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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)

Line 64: p_race 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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)
68: is

Line 65: p_community_fund 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,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)
68: is
69:

Line 66: p_ee_er_rate out nocopy hr_lookups.meaning%type,

62: p_religion out nocopy hr_lookups.meaning%type,
63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)
68: is
69:
70: l_meaning hr_lookups.meaning%type;

Line 67: p_payee_id_type out nocopy hr_lookups.meaning%type)

63: p_cpf_category out nocopy hr_lookups.meaning%type,
64: p_race out nocopy hr_lookups.meaning%type,
65: p_community_fund out nocopy hr_lookups.meaning%type,
66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)
68: is
69:
70: l_meaning hr_lookups.meaning%type;
71:

Line 70: l_meaning hr_lookups.meaning%type;

66: p_ee_er_rate out nocopy hr_lookups.meaning%type,
67: p_payee_id_type out nocopy hr_lookups.meaning%type)
68: 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

Line 79: (c_lookup_type hr_lookups.lookup_type%type,

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,
80: c_lookup_code hr_lookups.lookup_code%type) is
81: select meaning
82: from hr_lookups
83: where lookup_type = c_lookup_type

Line 80: c_lookup_code hr_lookups.lookup_code%type) is

76: where territory_code = c_territory_code;
77:
78: cursor sg_lookups
79: (c_lookup_type hr_lookups.lookup_type%type,
80: c_lookup_code hr_lookups.lookup_code%type) is
81: select meaning
82: from hr_lookups
83: where lookup_type = c_lookup_type
84: and lookup_code = c_lookup_code

Line 82: from hr_lookups

78: cursor sg_lookups
79: (c_lookup_type hr_lookups.lookup_type%type,
80: c_lookup_code hr_lookups.lookup_code%type) is
81: select meaning
82: from hr_lookups
83: where lookup_type = c_lookup_type
84: and lookup_code = c_lookup_code
85: and application_id = g_application_id;
86: begin