APPS.HZ_FORMAT_PUB dependencies on NLS_SESSION_PARAMETERS

Line 3408: FROM nls_session_parameters nls,

3404: if g_terr_code_exist = 0 then
3405: g_terr_code_exist :=1;
3406: SELECT fnd.territory_code
3407: INTO g_territory_code
3408: FROM nls_session_parameters nls,
3409: fnd_territories fnd
3410: WHERE nls.parameter = 'NLS_TERRITORY'
3411: AND fnd.nls_territory = nls.value;
3412: end if;

Line 3521: FROM nls_session_parameters nls,

3517: if g_terr_code_exist = 0 then
3518: g_terr_code_exist :=1;
3519: SELECT fnd.territory_code
3520: INTO g_territory_code
3521: FROM nls_session_parameters nls,
3522: fnd_territories fnd
3523: WHERE nls.parameter = 'NLS_TERRITORY'
3524: AND fnd.nls_territory = nls.value;
3525: end if;