DBA Data[Home] [Help]

APPS.PAY_KW_MONTHLY_REPORTS dependencies on FND_PROFILE

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

697: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
698: INSERT INTO fnd_sessions (session_id, effective_date)
699: VALUES (userenv('sessionid'), l_effective_date);
700:
701: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
702: l_local_nationality := NULL;
703: BEGIN
704: SELECT org_information1
705: INTO l_local_nationality

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

1202: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1203: INSERT INTO fnd_sessions (session_id, effective_date)
1204: VALUES (userenv('sessionid'), l_effective_date);
1205:
1206: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
1207: l_local_nationality := NULL;
1208: BEGIN
1209: SELECT org_information1
1210: INTO l_local_nationality

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

1792: /*l_eff_term_date := to_date('28-'||to_char(l_effective_date,'MM-YYYY'),'DD-MM-YYYY');*/
1793: INSERT INTO fnd_sessions (session_id, effective_date)
1794: VALUES (userenv('sessionid'), l_effective_date);
1795:
1796: l_user_format := NVL(FND_PROFILE.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'G');
1797: l_local_nationality := NULL;
1798: BEGIN
1799: SELECT org_information1
1800: INTO l_local_nationality