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

Line 1134: per_person_types b

1130: ,a.person_type_id
1131: ,a.effective_start_date
1132: ,a.effective_end_date
1133: from per_person_type_usages_f a,
1134: per_person_types b
1135: where a.person_id = l_dpnt_person_id
1136: and a.person_type_id = b.person_type_id
1137: and b.system_person_type = 'DPNT'
1138: and b.business_group_id = l_business_group_id

Line 1150: per_person_types b

1146: ,a.person_type_id
1147: ,a.effective_start_date
1148: ,a.effective_end_date
1149: from per_person_type_usages_f a,
1150: per_person_types b
1151: where a.person_id = l_dpnt_person_id
1152: and a.person_type_id = b.person_type_id
1153: and b.system_person_type = 'DPNT'
1154: and b.business_group_id = l_business_group_id

Line 2405: from per_person_types

2401: --
2402: --
2403: cursor get_dpnt_type_id_c is
2404: select person_type_id
2405: from per_person_types
2406: where system_person_type = 'DPNT'
2407: and business_group_id = l_business_group_id;
2408: --
2409: -- find overlapping ptu segments

Line 2585: per_person_types b

2581: a.object_version_number,
2582: a.effective_start_date,
2583: a.effective_end_date
2584: from per_person_type_usages_f a,
2585: per_person_types b
2586: where a.person_id = l_dpnt_person_id
2587: and a.person_type_id = b.person_type_id
2588: and b.system_person_type = 'DPNT'
2589: and b.business_group_id = l_business_group_id