APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_PROFILE

Line 852: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');

848: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
849: INSERT INTO fnd_sessions (session_id, effective_date)
850: VALUES (userenv('sessionid'), l_effective_date);
851:
852: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
853: l_local_nationality := NULL;
854: BEGIN
855: SELECT org_information1
856: INTO l_local_nationality

Line 1357: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');

1353: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1354: INSERT INTO fnd_sessions (session_id, effective_date)
1355: VALUES (userenv('sessionid'), l_effective_date);
1356:
1357: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
1358: l_local_nationality := NULL;
1359: BEGIN
1360: SELECT org_information1
1361: INTO l_local_nationality

Line 2014: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');

2010:
2011: INSERT INTO fnd_sessions (session_id, effective_date)
2012: VALUES (userenv('sessionid'), l_effective_date);
2013:
2014: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
2015: l_local_nationality := NULL;
2016: BEGIN
2017: SELECT org_information1
2018: INTO l_local_nationality