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_PDW_COPY_BEN_TO_STG dependencies on PER_PERSON_TYPES

Line 2841: This procedure is used to decode the person id for PER_PERSON_TYPES from lookup code

2837: End ;
2838:
2839:
2840: /*
2841: This procedure is used to decode the person id for PER_PERSON_TYPES from lookup code
2842: NB: There can be multiple user names for a given system name. For decoding we will have
2843: to limit the rows to 1. We can use the default one as specified by DEFAULT_FLAG ='Y'
2844: */
2845: --

Line 2869: Per_Person_Types ppt

2865: Select
2866:
2867: to_char(PERSON_TYPE_ID) into l_val
2868: From
2869: Per_Person_Types ppt
2870: Where
2871: ppt.System_Person_Type =p_val
2872: And ppt.ACTIVE_FLAG='Y'
2873: And ppt.Business_Group_Id = p_business_group_id