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.HRI_BPL_PERSON_TYPE dependencies on PER_PERSON_TYPES

Line 37: g_user_person_type per_person_types_tl.user_person_type%type;

33: g_cache_prsntyp_sk g_varchar240_tab_type;
34: g_cache_wkth_values g_wkth_cat_tab_type;
35:
36: -- globals to cache the person type information for performance.
37: g_user_person_type per_person_types_tl.user_person_type%type;
38: g_person_id per_all_people_f.person_id%type;
39: g_effective_date date;
40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;

Line 40: g_EMP_person_type per_person_types_tl.user_person_type%type;

36: -- globals to cache the person type information for performance.
37: g_user_person_type per_person_types_tl.user_person_type%type;
38: g_person_id per_all_people_f.person_id%type;
39: g_effective_date date;
40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;

Line 41: g_CWK_person_type per_person_types_tl.user_person_type%type;

37: g_user_person_type per_person_types_tl.user_person_type%type;
38: g_person_id per_all_people_f.person_id%type;
39: g_effective_date date;
40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;

Line 42: g_APL_person_type per_person_types_tl.user_person_type%type;

38: g_person_id per_all_people_f.person_id%type;
39: g_effective_date date;
40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;
46: g_OTHER_person_type per_person_types_tl.user_person_type%type;

Line 43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;

39: g_effective_date date;
40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;
46: g_OTHER_person_type per_person_types_tl.user_person_type%type;
47: g_CONCAT_person_type varchar2(4000);

Line 44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;

40: g_EMP_person_type per_person_types_tl.user_person_type%type;
41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;
46: g_OTHER_person_type per_person_types_tl.user_person_type%type;
47: g_CONCAT_person_type varchar2(4000);
48:

Line 45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;

41: g_CWK_person_type per_person_types_tl.user_person_type%type;
42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;
46: g_OTHER_person_type per_person_types_tl.user_person_type%type;
47: g_CONCAT_person_type varchar2(4000);
48:
49: -- constants.

Line 46: g_OTHER_person_type per_person_types_tl.user_person_type%type;

42: g_APL_person_type per_person_types_tl.user_person_type%type;
43: g_EXEMP_person_type per_person_types_tl.user_person_type%type;
44: g_EXCWK_person_type per_person_types_tl.user_person_type%type;
45: g_EXAPL_person_type per_person_types_tl.user_person_type%type;
46: g_OTHER_person_type per_person_types_tl.user_person_type%type;
47: g_CONCAT_person_type varchar2(4000);
48:
49: -- constants.
50: c_separator varchar2(1) := '.';

Line 122: FROM per_person_types_tl ttl

118: ,DECODE(typ.system_person_type
119: ,'OTHER'
120: ,ttl.user_person_type
121: ,NULL ) OTHER_PERSON_TYPE
122: FROM per_person_types_tl ttl
123: ,per_person_types typ
124: ,per_person_type_usages_f ptu
125: WHERE ttl.language = userenv('LANG')
126: AND ttl.person_type_id = typ.person_type_id

Line 123: ,per_person_types typ

119: ,'OTHER'
120: ,ttl.user_person_type
121: ,NULL ) OTHER_PERSON_TYPE
122: FROM per_person_types_tl ttl
123: ,per_person_types typ
124: ,per_person_type_usages_f ptu
125: WHERE ttl.language = userenv('LANG')
126: AND ttl.person_type_id = typ.person_type_id
127: AND typ.system_person_type IN ('APL','EMP','EX_APL','EX_EMP','CWK','EX_CWK','OTHER')

Line 320: per_person_types ppt

316: CURSOR emp_type_csr IS
317: SELECT
318: ppt.system_person_type
319: FROM
320: per_person_types ppt
321: ,per_person_type_usages_f ptu
322: WHERE ptu.person_id = p_person_id
323: AND p_effective_date
324: BETWEEN ptu.effective_start_date AND ptu.effective_end_date