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.

APPS.PER_SG_PERWSEPI dependencies on HR_LOOKUPS

Line 16: p_permit_type_code in hr_lookups.lookup_code%type,

12: -- Called from POST-QUERY trigger to obtain all the values
13: -- to display to the user in one hit.
14: procedure get_pddf_lookup_meanings
15: (p_country_code in fnd_territories_vl.territory_code%type,
16: p_permit_type_code in hr_lookups.lookup_code%type,
17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,

Line 17: p_permit_category_code in hr_lookups.lookup_code%type,

13: -- to display to the user in one hit.
14: procedure get_pddf_lookup_meanings
15: (p_country_code in fnd_territories_vl.territory_code%type,
16: p_permit_type_code in hr_lookups.lookup_code%type,
17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,

Line 18: p_nric_colour_code in hr_lookups.lookup_code%type,

14: procedure get_pddf_lookup_meanings
15: (p_country_code in fnd_territories_vl.territory_code%type,
16: p_permit_type_code in hr_lookups.lookup_code%type,
17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,

Line 19: p_religion_code in hr_lookups.lookup_code%type,

15: (p_country_code in fnd_territories_vl.territory_code%type,
16: p_permit_type_code in hr_lookups.lookup_code%type,
17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,

Line 20: p_cpf_category_code in hr_lookups.lookup_code%type,

16: p_permit_type_code in hr_lookups.lookup_code%type,
17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,

Line 21: p_race_code in hr_lookups.lookup_code%type,

17: p_permit_category_code in hr_lookups.lookup_code%type,
18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,

Line 22: p_community_fund_code in hr_lookups.lookup_code%type,

18: p_nric_colour_code in hr_lookups.lookup_code%type,
19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,

Line 23: p_ee_er_rate_code in hr_lookups.lookup_code%type,

19: p_religion_code in hr_lookups.lookup_code%type,
20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,

Line 24: p_payee_id_type_code in hr_lookups.lookup_code%type,

20: p_cpf_category_code in hr_lookups.lookup_code%type,
21: p_race_code in hr_lookups.lookup_code%type,
22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,

Line 26: p_permit_type out nocopy hr_lookups.meaning%type,

22: p_community_fund_code in hr_lookups.lookup_code%type,
23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,

Line 27: p_permit_category out nocopy hr_lookups.meaning%type,

23: p_ee_er_rate_code in hr_lookups.lookup_code%type,
24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,

Line 28: p_nric_colour out nocopy hr_lookups.meaning%type,

24: p_payee_id_type_code in hr_lookups.lookup_code%type,
25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,

Line 29: p_religion out nocopy hr_lookups.meaning%type,

25: p_country out nocopy fnd_territories_vl.territory_short_name%type,
26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,

Line 30: p_cpf_category out nocopy hr_lookups.meaning%type,

26: p_permit_type out nocopy hr_lookups.meaning%type,
27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,
34: p_payee_id_type out nocopy hr_lookups.meaning%type);

Line 31: p_race out nocopy hr_lookups.meaning%type,

27: p_permit_category out nocopy hr_lookups.meaning%type,
28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,
34: p_payee_id_type out nocopy hr_lookups.meaning%type);
35: end per_sg_perwsepi;

Line 32: p_community_fund out nocopy hr_lookups.meaning%type,

28: p_nric_colour out nocopy hr_lookups.meaning%type,
29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,
34: p_payee_id_type out nocopy hr_lookups.meaning%type);
35: end per_sg_perwsepi;

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

29: p_religion out nocopy hr_lookups.meaning%type,
30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,
34: p_payee_id_type out nocopy hr_lookups.meaning%type);
35: end per_sg_perwsepi;

Line 34: p_payee_id_type out nocopy hr_lookups.meaning%type);

30: p_cpf_category out nocopy hr_lookups.meaning%type,
31: p_race out nocopy hr_lookups.meaning%type,
32: p_community_fund out nocopy hr_lookups.meaning%type,
33: p_ee_er_rate out nocopy hr_lookups.meaning%type,
34: p_payee_id_type out nocopy hr_lookups.meaning%type);
35: end per_sg_perwsepi;