DBA Data[Home] [Help]

APPS.PER_RESPOWNER_UTIL_SS dependencies on FND_PROFILE

Line 70: (GNT.ctx_org_id = -1 OR GNT.ctx_org_id = FND_PROFILE.VALUE('ORG_ID')) AND

66: (expiration_date is NULL or expiration_date >= SYSDATE))))) AND
67: (GNT.ctx_secgrp_id = -1 OR GNT.ctx_secgrp_id = FND_GLOBAL.SECURITY_GROUP_ID) AND
68: (GNT.ctx_resp_id = -1 OR GNT.ctx_resp_id = FND_GLOBAL.RESP_ID) AND
69: (GNT.ctx_resp_appl_id = -1 OR GNT.ctx_resp_appl_id = FND_GLOBAL.RESP_APPL_ID) AND
70: (GNT.ctx_org_id = -1 OR GNT.ctx_org_id = FND_PROFILE.VALUE('ORG_ID')) AND
71: GNT.start_date <= sysdate AND
72: (GNT.end_date IS NULL OR GNT.end_date >= sysdate) AND
73: ((GNT.INSTANCE_TYPE = 'INSTANCE')
74: AND fr.responsibility_id = GNT.INSTANCE_PK1_VALUE