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.PO_HR_LOCATION dependencies on FND_GLOBAL

Line 111: FND_GLOBAL.lookup_security_group(flv1.lookup_type, flv1.view_application_id))

107: AND hrl.region_1 = flv1.lookup_code (+)
108: AND hrl.country || '_PROVINCE' = flv1.lookup_type (+)
109: AND DECODE(flv1.lookup_code, NULL, '1', flv1.security_group_id) =
110: DECODE(flv1.lookup_code, NULL, '1',
111: FND_GLOBAL.lookup_security_group(flv1.lookup_type, flv1.view_application_id))
112: AND DECODE(flv1.lookup_code, NULL, '1', flv1.view_application_id) =
113: DECODE(flv1.lookup_code, NULL, '1', 3)
114: AND DECODE(flv1.lookup_code, NULL, '1', flv1.language) =
115: DECODE(flv1.lookup_code, NULL, '1', USERENV('LANG'))

Line 120: FND_GLOBAL.lookup_security_group(flv2.lookup_type, flv2.view_application_id))

116: AND hrl.region_2 = flv2.lookup_code (+)
117: AND hrl.country || '_STATE' = flv2.lookup_type (+)
118: AND DECODE(flv2.lookup_code, NULL, '1', flv2.security_group_id) =
119: DECODE(flv2.lookup_code, NULL, '1',
120: FND_GLOBAL.lookup_security_group(flv2.lookup_type, flv2.view_application_id))
121: AND DECODE(flv2.lookup_code, NULL, '1', flv2.view_application_id) =
122: DECODE(flv2.lookup_code, NULL, '1', 3)
123: AND DECODE(flv2.lookup_code, NULL, '1', flv2.language) =
124: DECODE(flv2.lookup_code, NULL, '1', USERENV('LANG'))

Line 129: FND_GLOBAL.lookup_security_group(flv3.lookup_type, flv3.view_application_id))

125: AND hrl.region_1 = flv3.lookup_code (+)
126: AND hrl.country || '_COUNTY' = flv3.lookup_type (+)
127: AND DECODE(flv3.lookup_code, NULL, '1', flv3.security_group_id) =
128: DECODE(flv3.lookup_code, NULL, '1',
129: FND_GLOBAL.lookup_security_group(flv3.lookup_type, flv3.view_application_id))
130: AND DECODE(flv3.lookup_code, NULL, '1', flv3.view_application_id) =
131: DECODE(flv3.lookup_code, NULL, '1', 3)
132: AND DECODE(flv3.lookup_code, NULL, '1', flv3.language) =
133: DECODE(flv3.lookup_code, NULL, '1', USERENV('LANG'))

Line 138: FND_GLOBAL.lookup_security_group(flv4.lookup_type, flv4.view_application_id))

134: AND hrl.town_or_city = flv4.lookup_code(+)
135: AND hrl.country || '_PROVINCE' = flv4.lookup_type (+)
136: AND DECODE(flv4.lookup_code, NULL, '1', flv4.security_group_id) =
137: DECODE(flv4.lookup_code, NULL, '1',
138: FND_GLOBAL.lookup_security_group(flv4.lookup_type, flv4.view_application_id))
139: AND DECODE(flv4.lookup_code, NULL, '1', flv4.view_application_id) =
140: DECODE(flv4.lookup_code, NULL, '1', 3)
141: AND DECODE(flv4.lookup_code, NULL, '1', flv4.language) =
142: DECODE(flv4.lookup_code, NULL, '1', USERENV('LANG'))

Line 203: FND_GLOBAL.lookup_security_group(flv1.lookup_type, flv1.view_application_id))

199: AND hzl.county = flv1.lookup_code (+)
200: AND hzl.country || '_PROVINCE' = flv1.lookup_type (+)
201: AND DECODE(flv1.lookup_code, NULL, '1', flv1.security_group_id) =
202: DECODE(flv1.lookup_code, NULL, '1',
203: FND_GLOBAL.lookup_security_group(flv1.lookup_type, flv1.view_application_id))
204: AND DECODE(flv1.lookup_code, NULL, '1', flv1.view_application_id) =
205: DECODE(flv1.lookup_code, NULL, '1', 3)
206: AND DECODE(flv1.lookup_code, NULL, '1', flv1.language) =
207: DECODE(flv1.lookup_code, NULL, '1', USERENV('LANG'))

Line 212: FND_GLOBAL.lookup_security_group(flv2.lookup_type, flv2.view_application_id))

208: AND hzl.state = flv2.lookup_code (+)
209: AND hzl.country || '_STATE' = flv2.lookup_type (+)
210: AND DECODE(flv2.lookup_code, NULL, '1', flv2.security_group_id) =
211: DECODE(flv2.lookup_code, NULL, '1',
212: FND_GLOBAL.lookup_security_group(flv2.lookup_type, flv2.view_application_id))
213: AND DECODE(flv2.lookup_code, NULL, '1', flv2.view_application_id) =
214: DECODE(flv2.lookup_code, NULL, '1', 3)
215: AND DECODE(flv2.lookup_code, NULL, '1', flv2.language) =
216: DECODE(flv2.lookup_code, NULL, '1', USERENV('LANG'))

Line 221: FND_GLOBAL.lookup_security_group(flv3.lookup_type, flv3.view_application_id))

217: AND hzl.county = flv3.lookup_code (+)
218: AND hzl.country || '_COUNTY' = flv3.lookup_type (+)
219: AND DECODE(flv3.lookup_code, NULL, '1', flv3.security_group_id) =
220: DECODE(flv3.lookup_code, NULL, '1',
221: FND_GLOBAL.lookup_security_group(flv3.lookup_type, flv3.view_application_id))
222: AND DECODE(flv3.lookup_code, NULL, '1', flv3.view_application_id) =
223: DECODE(flv3.lookup_code, NULL, '1', 3)
224: AND DECODE(flv3.lookup_code, NULL, '1', flv3.language) =
225: DECODE(flv3.lookup_code, NULL, '1', USERENV('LANG'))

Line 419: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND

415: HLC.REGION_1 = FCL1.LOOKUP_CODE (+) AND
416: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
417: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
418: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
419: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
420: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
421: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
422: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
423: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 428: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND

424: HLC.REGION_2 = FCL2.LOOKUP_CODE (+) AND
425: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
426: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
427: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
428: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
429: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
430: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
431: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
432: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 437: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND

433: HLC.REGION_1 = FCL3.LOOKUP_CODE (+) AND
434: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
435: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
436: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
437: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
438: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
439: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
440: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
441: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 446: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE, FCL4.VIEW_APPLICATION_ID)) AND

442: HLC.TOWN_OR_CITY = FCL4.LOOKUP_CODE (+) AND
443: HLC.COUNTRY || '_PROVINCE' = FCL4.LOOKUP_TYPE (+) AND
444: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.SECURITY_GROUP_ID) =
445: DECODE(FCL4.LOOKUP_CODE, NULL, '1',
446: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE, FCL4.VIEW_APPLICATION_ID)) AND
447: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.VIEW_APPLICATION_ID) =
448: DECODE(FCL4.LOOKUP_CODE, NULL, '1', 3) AND
449: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.LANGUAGE) =
450: DECODE(FCL4.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

Line 517: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND

513: HLC.county = FCL1.LOOKUP_CODE (+) AND
514: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
515: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
516: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
517: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
518: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
519: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
520: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
521: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 526: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND

522: HLC.state = FCL2.LOOKUP_CODE (+) AND
523: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
524: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
525: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
526: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
527: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
528: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
529: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
530: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 535: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND

531: HLC.county = FCL3.LOOKUP_CODE (+) AND
532: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
533: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
534: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
535: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
536: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
537: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
538: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
539: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

Line 764: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND

760: HLC.REGION_1 = FCL1.LOOKUP_CODE (+) AND
761: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
762: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
763: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
764: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
765: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
766: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
767: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
768: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 773: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND

769: HLC.REGION_2 = FCL2.LOOKUP_CODE (+) AND
770: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
771: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
772: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
773: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
774: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
775: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
776: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
777: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 782: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND

778: HLC.REGION_1 = FCL3.LOOKUP_CODE (+) AND
779: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
780: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
781: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
782: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
783: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
784: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
785: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
786: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 791: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE, FCL4.VIEW_APPLICATION_ID)) AND

787: HLC.TOWN_OR_CITY = FCL4.LOOKUP_CODE (+) AND
788: HLC.COUNTRY || '_PROVINCE' = FCL4.LOOKUP_TYPE (+) AND
789: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.SECURITY_GROUP_ID) =
790: DECODE(FCL4.LOOKUP_CODE, NULL, '1',
791: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL4.LOOKUP_TYPE, FCL4.VIEW_APPLICATION_ID)) AND
792: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.VIEW_APPLICATION_ID) =
793: DECODE(FCL4.LOOKUP_CODE, NULL, '1', 3) AND
794: DECODE(FCL4.LOOKUP_CODE, NULL, '1', FCL4.LANGUAGE) =
795: DECODE(FCL4.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

Line 1043: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND

1039: HLC.county = FCL1.LOOKUP_CODE (+) AND
1040: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
1041: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
1042: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
1043: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
1044: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
1045: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
1046: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
1047: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 1052: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND

1048: HLC.state = FCL2.LOOKUP_CODE (+) AND
1049: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
1050: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
1051: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
1052: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
1053: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
1054: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
1055: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
1056: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

Line 1061: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND

1057: HLC.county = FCL3.LOOKUP_CODE (+) AND
1058: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
1059: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
1060: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
1061: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
1062: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
1063: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1064: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1065: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;