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.

[Home] [Help]

APPS.PO_HR_LOCATION dependencies on FND_GLOBAL

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

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

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

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

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

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

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

188: AND hzl.county = flv1.lookup_code (+)
189: AND hzl.country || '_PROVINCE' = flv1.lookup_type (+)
190: AND DECODE(flv1.lookup_code, NULL, '1', flv1.security_group_id) =
191: DECODE(flv1.lookup_code, NULL, '1',
192: FND_GLOBAL.lookup_security_group(flv1.lookup_type, flv1.view_application_id))
193: AND DECODE(flv1.lookup_code, NULL, '1', flv1.view_application_id) =
194: DECODE(flv1.lookup_code, NULL, '1', 3)
195: AND DECODE(flv1.lookup_code, NULL, '1', flv1.language) =
196: DECODE(flv1.lookup_code, NULL, '1', USERENV('LANG'))

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

197: AND hzl.state = flv2.lookup_code (+)
198: AND hzl.country || '_STATE' = flv2.lookup_type (+)
199: AND DECODE(flv2.lookup_code, NULL, '1', flv2.security_group_id) =
200: DECODE(flv2.lookup_code, NULL, '1',
201: FND_GLOBAL.lookup_security_group(flv2.lookup_type, flv2.view_application_id))
202: AND DECODE(flv2.lookup_code, NULL, '1', flv2.view_application_id) =
203: DECODE(flv2.lookup_code, NULL, '1', 3)
204: AND DECODE(flv2.lookup_code, NULL, '1', flv2.language) =
205: DECODE(flv2.lookup_code, NULL, '1', USERENV('LANG'))

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

206: AND hzl.county = flv3.lookup_code (+)
207: AND hzl.country || '_COUNTY' = flv3.lookup_type (+)
208: AND DECODE(flv3.lookup_code, NULL, '1', flv3.security_group_id) =
209: DECODE(flv3.lookup_code, NULL, '1',
210: FND_GLOBAL.lookup_security_group(flv3.lookup_type, flv3.view_application_id))
211: AND DECODE(flv3.lookup_code, NULL, '1', flv3.view_application_id) =
212: DECODE(flv3.lookup_code, NULL, '1', 3)
213: AND DECODE(flv3.lookup_code, NULL, '1', flv3.language) =
214: DECODE(flv3.lookup_code, NULL, '1', USERENV('LANG'))

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

402: HLC.REGION_1 = FCL1.LOOKUP_CODE (+) AND
403: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
404: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
405: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
406: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
407: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
408: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
409: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
410: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

411: HLC.REGION_2 = FCL2.LOOKUP_CODE (+) AND
412: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
413: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
414: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
415: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
416: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
417: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
418: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
419: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

420: HLC.REGION_1 = FCL3.LOOKUP_CODE (+) AND
421: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
422: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
423: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
424: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
425: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
426: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
427: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
428: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

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

491: HLC.county = FCL1.LOOKUP_CODE (+) AND
492: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
493: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
494: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
495: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
496: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
497: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
498: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
499: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

500: HLC.state = FCL2.LOOKUP_CODE (+) AND
501: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
502: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
503: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
504: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
505: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
506: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
507: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
508: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

509: HLC.county = FCL3.LOOKUP_CODE (+) AND
510: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
511: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
512: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
513: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
514: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
515: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
516: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
517: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

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

736: HLC.REGION_1 = FCL1.LOOKUP_CODE (+) AND
737: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
738: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
739: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
740: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
741: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
742: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
743: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
744: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

745: HLC.REGION_2 = FCL2.LOOKUP_CODE (+) AND
746: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
747: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
748: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
749: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
750: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
751: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
752: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
753: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

754: HLC.REGION_1 = FCL3.LOOKUP_CODE (+) AND
755: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
756: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
757: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
758: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
759: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
760: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
761: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
762: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;

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

1006: HLC.county = FCL1.LOOKUP_CODE (+) AND
1007: HLC.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+) AND
1008: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.SECURITY_GROUP_ID) =
1009: DECODE(FCL1.LOOKUP_CODE, NULL, '1',
1010: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE, FCL1.VIEW_APPLICATION_ID)) AND
1011: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.VIEW_APPLICATION_ID) =
1012: DECODE(FCL1.LOOKUP_CODE, NULL, '1', 3) AND
1013: DECODE(FCL1.LOOKUP_CODE, NULL, '1', FCL1.LANGUAGE) =
1014: DECODE(FCL1.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

1015: HLC.state = FCL2.LOOKUP_CODE (+) AND
1016: HLC.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+) AND
1017: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.SECURITY_GROUP_ID) =
1018: DECODE(FCL2.LOOKUP_CODE, NULL, '1',
1019: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE, FCL2.VIEW_APPLICATION_ID)) AND
1020: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.VIEW_APPLICATION_ID) =
1021: DECODE(FCL2.LOOKUP_CODE, NULL, '1', 3) AND
1022: DECODE(FCL2.LOOKUP_CODE, NULL, '1', FCL2.LANGUAGE) =
1023: DECODE(FCL2.LOOKUP_CODE, NULL, '1', USERENV('LANG')) AND

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

1024: HLC.county = FCL3.LOOKUP_CODE (+) AND
1025: HLC.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+) AND
1026: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.SECURITY_GROUP_ID) =
1027: DECODE(FCL3.LOOKUP_CODE, NULL, '1',
1028: FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE, FCL3.VIEW_APPLICATION_ID)) AND
1029: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.VIEW_APPLICATION_ID) =
1030: DECODE(FCL3.LOOKUP_CODE, NULL, '1', 3) AND
1031: DECODE(FCL3.LOOKUP_CODE, NULL, '1', FCL3.LANGUAGE) =
1032: DECODE(FCL3.LOOKUP_CODE, NULL, '1', USERENV('LANG')) ;